SQL statement - date
| From: | Jacques | Date: | Wed, 23 Mar 2005 09:41:56 +0000 |
| Subject: | SQL statement - date | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-211371@lists.php.net to get a copy of this message | ||
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