Re: syntax
| From: | Rick Duval | Date: | Wed, 25 Feb 2009 14:48:54 +0000 |
| Subject: | Re: syntax | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-288785@lists.php.net to get a copy of this message | ||
WHERE
date >= DATE_SUB(NOW(), INTERVAL 7 DAY)
Works just fine for me.
R
On Tue, Feb 24, 2009 at 4:15 PM, Terion Miller <webdev.terion@gmail.com>wrote:
> Need syntax help when it comes to using a timestamp.
> What I'm trying to say in my query WHERE clause is to select records if the
> timestamp on the record is in the past 7 days from NOW()
>
> $query .= " WHERE stamp < NOW()-7 "; I have no clue here on this ....
>
> the lay language is WHERE stamp is within the past 7 days.... how to php
> that? lol
> 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."
>
> --
> This message has been scanned for
> viruses and dangerous content by
> Accurate Anti-Spam Technologies
> and is believed to be clean.
> Info@AccurateAntiSpam.com
>
>
![http://badge.facebook.com/badge/1542024891.237.919247960.png"](http://badge.facebook.com/badge/1542024891.237.919247960.png"){kind=link}