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

Reply via email to