Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

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


X1Tech

Recommended Posts

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

Link to comment
Share on other sites

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:
Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...