Re: SQL statement - date

[Jesper Goos <jesper@xxxxxxxxxx>]

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