Re: [PHP] SQL statement - date

[Jesper Goos]

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 

 

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php