|
|
Posted by Jerry Stuckle on 11/19/06 23:05
Greg Scharlemann wrote:
> 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
>
If it's MySQL, you can do it all in SQL:
$result = mysql_query('SELECT myColumn FROM myTable where datacol=
SUBDATE(NOW(), INTERVAL 7 DAY))';
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|