On Oct 2, 2008, at 12:39 PM, Per Jessen wrote:
Jason Pruim wrote:
Hi Everyone,
I am working on a app where I need to be able to select all the
values
from a database where the 'timein' field is between a certain date
range... Essentially the last 7 days...
SELECT * FROM timeStore WHERE timein>DATE_SUB(now(),INTERVAL 7 DAYS)
Hmmm... To do that, I'd have to store the date/timestamps in a
different format...
I'll look into this more, but I think I'd have to rewrite the program
to make that work.
Thanks for the suggestion though!
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
11287 James St
Holland, MI 49424
www.raoset.com
japruim@xxxxxxxxxx
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
