20 Aug 2010, 12:50 PM
Oba-san
- Join Date:
- Sep 2003
- Location:
- Ohio
- Posts:
- 62,757
- Plugin Contributions:
- 1
Interesting Problem - Displaying Certain Products in Category, But NOT in All prducts
Both SELECT statements need the $where_str on them ...
$specials_index_query = "select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, p.products_quantity,
p.products_date_added, p.products_price, p.products_type, p.products_model,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_str . $display_limit;
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
