Trusten Posted November 8, 2002 Share Posted November 8, 2002 I can't seem to get the new products random like i once had. please help. Link to comment Share on other sites More sharing options...
Trusten Posted November 8, 2002 Author Share Posted November 8, 2002 bump Link to comment Share on other sites More sharing options...
mikimoto Posted January 31, 2003 Share Posted January 31, 2003 same question :roll: Link to comment Share on other sites More sharing options...
burt Posted January 31, 2003 Share Posted January 31, 2003 if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' AND p.products_image != '' AND p.products_image != 'Array' order by RAND() DESC limit " . MAX_DISPLAY_NEW_PRODUCTS); } else { $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . $new_products_category_id . "' and p.products_status = '1' order by RAND() DESC limit " . MAX_DISPLAY_NEW_PRODUCTS); } Shows products *with an image* randomly on page reload. Works in the 14/01/2003 snapshot. Link to comment Share on other sites More sharing options...
mikimoto Posted January 31, 2003 Share Posted January 31, 2003 All right now :) Thank you very much :wink: Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.