gilurv Posted January 3, 2008 Share Posted January 3, 2008 Hello, i have the box default_specials.php showing on my index page, it is great but i need to make it better. is there a way that i could change this code: ******* $new = tep_db_query( "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and s.status = '1' order by rand() DESC limit 9"); ******* so that instead of taking at random withing all products on specials, i could have it so that it only show items on specials from a specific cathegory id? thank you! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.