Random Featured Products
Submitted by nazeelp on Sun, 2006-07-23 15:36.Price Tapestry
Is there any way to show 5 featured products randomly from the list of featured products.
Best Regards
Nazeel
Hi David,
I use this upper code, but I want to restrict the results to only 1 of 2 merchants. How can I manage that?
Regards
Roland
Hi Nazeel,
The featured products are selected with this code on line 32 of index.php:
$sql = "SELECT * FROM `".$config_databaseTablePrefix."featured` ORDER BY sequence";To make it pick 5 random products from the list of featured products, change that line to the following:
$sql = "SELECT * FROM `".$config_databaseTablePrefix."featured` ORDER BY RAND() LIMIT 5";Cheers,
David.