Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 VP-ASP 6.50 Features and Facilities
 New Item search
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

DanR
Starting Member

4 Posts

Posted - March 14 2006 :  13:07:13  Show Profile  Reply with Quote
Any one have a simple way to return new items.

What I want is to return all new Items in the last 10 days.

Thanks

dandlyin
VP-CART New User

USA
73 Posts

Posted - April 04 2006 :  21:54:27  Show Profile  Visit dandlyin's Homepage  Reply with Quote
This SQL statement should do it:
SELECT * FROM products where (hide=0 and cdateadded >=(date()-10)) order by cdateadded DESC
Hope this helps you.
Dan Dotson
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00