comparing stored timestamp with NOW()

From:	Terion Miller	Date:	Tue, 24 Feb 2009 21:35:06 +0000
Subject:	comparing stored timestamp with NOW()
Groups:	php.db
Request:	Send a blank email to php-db+get-46005@lists.php.net to get a copy of this message

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."