Re: syntax
| From: | Chris | Date: | Tue, 24 Feb 2009 21:28:13 +0000 |
| Subject: | Re: syntax | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-288763@lists.php.net to get a copy of this message | ||
Terion Miller 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? lolHas nothing at all to do with php. http://dev.mysql.com/doc/refman/5.0/en/datetime.html http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html -- Postgresql & php tutorials http://www.designmagick.com/