Posted by Jacques on 10/20/16 11:11

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

• Next in forum: php pattern, software development pattern
• Prev in forum: Re: reduce the following code "if ($colorVar == 'Black' || $colorVar == 'Red' || $colorVar == 'White' || $colorVar == 'Blue' ){"
• Thread view: SQL statement - date

[Reply to this message]