New Products Sidebox Show Products from one category?

[flirt4]

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.

[Ajeh]

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 ...