display sub catagory items

[vwebworld]

I think this code (in index.php) enables the catagory items appear:

$current_category_id = 59;

$listing_sql = "select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '".$current_category_id."' order by p.products_date_added DESC limit 3";

$new_products_query = tep_db_query($listing_sql);

 

How do I change it to show subcatagory itmes?

I tried changing $current_category_id = 59; to = 59_70 (a sub-catagory)

but that produces an error.

 

Thanks, Roland

[♥Monika in Germany]

please do not tell me you have hardcoded category links ...

 

anyway, only the last value of a cPath is the "current_category_id" that is needed for the query ...

[vwebworld]

please do not tell me you have hardcoded category links ...

 

anyway, only the last value of a cPath is the "current_category_id" that is needed for the query ...

 

Thanks. The catagory # is specified so that the itmes from certain

specific catagories appear on the home page.

 

~Roland

[jasonabc]

Use Featured Products to do this instead