VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 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-ASP 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