Rich,
Did you try putting "WHERE" twice?
try:
SELECT * FROM WEEKS WHERE BEGIN >= CURDATE() and WHERE END <= CURDATE;
Jordan
On Sep 13, 2005, at 9: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
