Need help with a "=" code ... any takers

clarocque <[email protected]>
Newsgroups gmane.comp.web.oscommerce.general
Message-ID <0d96b1b1c811c61a8f04c831b506284d@osCommerce-Forums>
This message was sent from: General Support
http://forums.oscommerce.com/viewtopic.php?p=227159#227159
----------------------------------------------------------------

I posted this ealrier with no luck any takers now?

Can anyone tell me what I have to change to get my specials window to show items with more thatn one status id? 

I have changed it so I can set the status id to: 
1 for window # 1 
2 for window # 3 
3 for window # 1 and 2 

But how do i set the /includes/boxes/specials.php to show 1 or 3? 

this is the code for that but I dont know how to change the one to allow 1 or 3. 

[code]
if ($random_product = tep_random_select("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 p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS)) { 

[/code]
Any help would be greatly appreciated... 

Chris
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.