Random items on home page

[Fez-o Joe]

I would like to set up "Featured Products" on my home page to appear in random order every time the page is refreshed. Can this be done with settings or by some other means?

It is controlled via the Admin panel (Config/Max Values) and it has the same programming as the New Products... it'll pick a random product_id then increment from there. Just looking over the code in the featured_products.php - it appears akin to the new_products - so the same code mod should work.

Remember to backup. Always.

[cyberfolli]

What if I wanted to Hard code a specific category say cat id = 1

when i add a where it just defaults to random.. for some reason trying to specify a category in the admin gets me nowhere either!

$new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
p.products_date_added, p.products_price, p.products_type, p.master_categories_id
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
where p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and p.products_status = 1 WHERE p.master_categories_id = '1'
and p.products_id in (" . $list_of_products . ")";

[Ajeh]

You cannot have 2 WHERE statements in there;

$new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
p.products_date_added, p.products_price, p.products_type, p.master_categories_id
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
where p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and p.products_status = 1 WHERE p.master_categories_id = '1'
and p.products_id in (" . $list_of_products . ")";

you want to add a new AND to that existing WHERE if you are trying to limit the Products to be those coming just from Products using master_categories_id 1 with:

$new_products_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
p.products_date_added, p.products_price, p.products_type, p.master_categories_id
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
where p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and p.products_status = 1 
and p.master_categories_id = '1'
and p.products_id in (" . $list_of_products . ")";

[cyberfolli]

Wow thank you.. That was the answer..

[Ajeh]

Thanks for the update that this worked for you ...

[jam1968]

I'm trying this aswell, but I don't think I'm using sideboxes. I was wondering what php file that I should look at editig with this code. I would like to show fully randimized products to.
http://www.mutt-lover.com