Hi David
I want to display products on my home page that change every day is that possible from a list of specified featured products
thanks
robert,
Personally I use random products from the whole database, so if you wanted to do that
$sql = "SELECT * FROM `".$config_databaseTablePrefix."products` ORDER BY RAND() LIMIT 3";
It does reasonably take about a secondish but at least you don't have to worry about putting actual products into the featured.
Maybe I'm just being lazy, the featured is cool if there is something particular you want people to find, e.g seasonal related products, but I hate sitting there finding the products myself and then copying the whole text so that it displays.
Thats an idea, is it possible to say put in the featured box, say Nintendo, BBQ etc, so that it looks for products such as those and displays?
Would save a lot of time.
Hi Robert,
No probs - it's an easy mod to make the featured products a random selection from what then becomes your list of "possible" featured products. The change is in the following thread:
http://www.pricetapestry.com/node/353
Cheers!
David.