Re: [PHP-DB] comparing stored timestamp with NOW()

$days = 7;
$now = date(Y-m-d);
$timestamp = /*your defined stamp */;
$query = "SELECT * from TABLE WHERE DATEDIFF('$timestamp', '$now')<=7";

I think that is the query you want? Unless I'm misreading the manual -
which is entirely possible.

Conversely you can just use DATEDIFF('$timestamp', DATE())<=7 as well.
The only thing you need to make sre is that your $timestamp is in
YYYY-MM-DD format.

On Tue, Feb 24, 2009 at 4:35 PM, Terion Miller <[email protected]> wrote:
> Hi I need help formatting a sql statement that compares my stored timestamp
> $stamp with NOW()
> what I'm trying to do is generate a SELECT statement that pulls only records
> within 7 days of NOW()
> should i use
>
>  *SELECT DATEDIFF('stamp','NOW()')=7d; not sure how the difference
> part is syntaxed*
>
> Thanks
> Terion
>
> Happy Freecycling
> Free the List !!
> www.freecycle.org
> Over Moderation of Freecycle List Prevents Post Timeliness.
> ------------------------------------------------
> Twitter?
> http://twitter.com/terionmiller
> ------------------------------------------------
> Facebook:
> <a href="http://www.facebook.com/people/Terion-Miller/1542024891"
> title="Terion Miller's Facebook profile" target=_TOP><img src="
> http://badge.facebook.com/badge/1542024891.237.919247960.png" border=0
> alt="Terion Miller's Facebook profile"></a>
> Vince Lombardi  - "Winning is habit. Unfortunately, so is losing."
>