help with mod code

This message was sent from: General Support
http://forums.oscommerce.com/viewtopic.php?p=226901#226901
----------------------------------------------------------------

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