|
Posted by Greg Scharlemann on 11/19/06 22:52
I have a series of records in a database. When each record is stored,
the datetime is logged: $date = date("Y-m-d H:i:s");
Prior to adding a new record to the database, I want to run a query to
retrieve all of the records uploaded in the last 7 days. I thought it
would be easiest to:
Pseudo Code:
$newDate = $date - 7 days;
select * from TABLE where DATE > $newDate;
Problem is I can't figure out how to subtract 7 days from $date and
convert that value to a valid datetime object.
Thanks for any help
Navigation:
[Reply to this message]
|