Re: Question on CURDATE()
| From: | Jordan Miller | Date: | Wed, 14 Sep 2005 02:45:55 +0000 |
| Subject: | Re: Question on CURDATE() | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40268@lists.php.net to get a copy of this message | ||
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