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@xxxxxxxxxxxxxxxxxx] Sent: Tuesday, September 13, 2005 9:13 PM To: php-db@xxxxxxxxxxxxx Subject: Re: 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
