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

Reply via email to