Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Specials box only showing items from a category?


gilurv

Recommended Posts

Hello,

 

i have the box default_specials.php showing on my index page, it is great but i need to make it better.

 

is there a way that i could change this code:

 

*******

$new = tep_db_query( "select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and s.status = '1' order by rand() DESC limit 9");

*******

 

so that instead of taking at random withing all products on specials, i could have it so that it only show items on specials from a specific cathegory id?

 

thank you!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...