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