Re: Question on CURDATE()
| From: | Micah Stevens | Date: | Wed, 14 Sep 2005 02:13:27 +0000 |
| Subject: | Re: Question on CURDATE() | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40265@lists.php.net to get a copy of this message | ||
What SQL server are you using?
On Tuesday 13 September 2005 7:08 pm, reclmaples wrote:
> I am trying to write a statement that will basically do this:
>
> SELECT * FROM WEEKS WHERE BEGIN >= CURDATE() and END <= CURDATE;
>
> But for some reason I can only use one CURDATE() reference in my sql
> statement, does anyone know why? Is there a way I can get around this?
>
>
> Any help would be greatly appreciated.
>
> Thanks
> -Rich