is it possible to feature a random selection of featured products on the home page based on a number of keywords/products etc?
regards
Hi,
Sure - you'll see the basic modification for making featured products random on this page:
http://www.pricetapestry.com/node/2276
If you wanted to limit the random results by keyword, you can modify the replacement SQL as shown in the above thread as follows:
$sql = "SELECT name,1 AS sequence FROM `".$config_databaseTablePrefix."products` WHERE name LIKE '%keyword%' ORDER BY RAND() LIMIT 3";
Cheers, David.
©2006-2025 IAAI Software | Contact Us | Privacy Policy
Hi,
Sure - you'll see the basic modification for making featured products random on this page:
http://www.pricetapestry.com/node/2276
If you wanted to limit the random results by keyword, you can modify the replacement SQL as shown in the above thread as follows:
$sql = "SELECT name,1 AS sequence FROM `".$config_databaseTablePrefix."products` WHERE name LIKE '%keyword%' ORDER BY RAND() LIMIT 3";Cheers,
David.