Re: SQL statement - date
| From: | kyriacos sakkas | Date: | Wed, 06 Apr 2005 08:18:47 +0000 |
| Subject: | Re: SQL statement - date | ||
| References: | 1 | Groups: | php.general php.general |
| Request: | Send a blank email to php-general+get-212381@lists.php.net to get a copy of this message | ||
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
this should work (please adjust date format to your needs):
BETWEEN
date('Y-m-d') AND date('Y-m-d',mktime(0, 0, 0, date("m"),
date("d")-7,date("Y")))";
Regards Kyriacos