Forums / Setting Up Categories, Products, Attributes / New Products Sidebox Show Products from one category?

New Products Sidebox Show Products from one category?

Locked

Views: 2,151

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
22 Jul 2007, 2:06 PM
#1
flirt4 avatar

flirt4

New Zenner

Join Date:
Feb 2007
Posts:
28
Plugin Contributions:
0

New Products Sidebox Show Products from one category?

Hi!

I want in my new products sidebox category on main page to show only products from one main category like when is selected this category.

For Example: I have two main categories "t-shirts" and "jenas". On main page in new products sidebox show new products from both categories, buth i want products only from "t-shirts" to be showed.

I look at code of new_products.php and I thing that must change this sql query:

"select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, p.products_date_added
from " . TABLE_PRODUCTS . " p
where p.products_status = 1 " . $display_limit"

...but I dont know how.

23 Jul 2007, 6:54 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: New Products Sidebox Show Products from one category?

If you do not use linked products, then the easiest method would be to use the master_categories_id in the select statement to limit the categories_id being shown when on the main page ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

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!