Re: SQL statement - date

From: Date: Wed, 23 Mar 2005 09:53:38 +0000
Subject: Re: SQL statement - date
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-211373@lists.php.net to get a copy of this message
take a look here http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html the first example should help you... regards jesper Jacques wrote:
How should I formulate my sql statement to create a result set of members who registered between now and 7 days ago? I have tried the following and it is obviously incorrect: $sqlnewmembers = "Select uid, uprofilename from tblusers where udatereg between (date() and date() - 7)"; Regards Jacques


« previous php.general (#211373) next »