Re: [PHP] SQL statement - date

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

[PHP] SQL statement - date

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 Jacq