You can't do that in SQL, that would give you a big fat syntax error. On Tuesday 13 September 2005 7:45 pm, Jordan Miller wrote: > 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
