RE: [PHP-DB] Question on CURDATE()
| From: | reclmaples | Date: | Wed, 14 Sep 2005 02:20:05 +0000 |
| Subject: | RE: [PHP-DB] Question on CURDATE() | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40266@lists.php.net to get a copy of this message | ||
I am using mysql Ver 12.22 Distrib 4.0.16
Sorry for not including that.
Thanks
-Rich
-----Original Message-----
From: Micah Stevens [mailto:micah@raincross-tech.com]
Sent: Tuesday, September 13, 2005 9:13 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Question on CURDATE()
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php