How do I limit the time an item is considered NEW products_new.php

[X1Tech]

I have item that are over 4 months old listed in new products products_new.php

I have a total of 3500 products and 2300 of them are listed in NEW PRODUCTS and are up to 4 months old

How would I limit the result to something like last 30 days 60 days etc.

 

I have been over the products_new.php page code over and over and can not seem to have a positive effect on the amount of results or limiting the query returned to build the page.

 

Any insight would be wonderful.

 

oscommerce ROCKS ...just need to bend it a little to fit my needs.

 

NOTE: I did review the documentation but the documented suggestion of adding limit to the query

on http://www.oscommerce.info/kb/osCommerce/G..._and_Tricks/264 but it no longer applies to the current version

[Jan Zonjee]

NOTE: I did review the documentation but the documented suggestion of adding limit to the query

on http://www.oscommerce.info/kb/osCommerce/G..._and_Tricks/264 but it no longer applies to the current version

Actually, the code mentioned for the query is for osC version 3 (the upcoming version) but what you can add to the query is still relevant:

We are adding this code right before the "order by" code at the very end: