Version of zencart: 1.3.7 (my server runs php 4.something), so i can't upgrade any higher.
Site has been up and running fine for ages.

Hi all

Basically there is one category from which we don't want any of the subcategories/products to appear on the whats new page,

I can't work out how to prevent this using the admin, so i guess I will have to use an override,

What i am thinking is to utilise a field that i don't use in the product listing, in this case MODEL and I will add a key word in there if i don't want the product to show up on the New Products page, the keyword would be "HIDE", so i would then alter the New Products query to add something like
where model != "HIDE" ---- (is that how you write not equal in mysql), sorry have a toddler helping me type and I can't think straight
But I can't find the query for the "new products" page


Things I have already ruled out
ALTERING THE DATE IN THE DATABASE IS NOT SUITABLE IN THIS SITUATION AS WE WANT THE CORRECT ADDED DATE displayed
Using the parent category number in the query to block it - we have subcategories within subcategories and not all the products are at the same level if you get my meaning so we would have to add all the subcategories to an exclusion list (and there are regularly more added), or we have to do a subqueries to get the parent of the parent etc

Any help would be greatly appreciated