.16
Sorry for not including that.
Thanks
-Rich
-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 9:13 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Question on CURDATE()
What SQL server are you using?
On Tuesday 13 September 2005 7:08 pm
Hi,
I just noticed I was wrong, the original SQL statement would return rows, but
only if BEGIN = CURDATE(). I stated it would never happen, and that's wrong.
Sorry. :)
-Micah
On Tuesday 13 September 2005 9:42 pm, Micah Stevens wrote:
> Hi Jordan,
>
> Syntactically, there is no restriction
Hi Jordan,
Syntactically, there is no restriction on OR'ing or AND'ing conditions. You
could very well do this:
Select somefield where otherfield = 1 and otherfield = 2;
Of course, otherfield would never be both 1 and 2, so this is a worthless
select statement, however, my point is, there woul
Micah,
Oh, my bad. I was trying to remember how I did something like this
before, stringing together a lot of "WHERE"s. You're right, though,
it wasn't "WHERE", it was "OR".
Rich,
I think you need "OR" instead of "AND", OR else I'm just totally out
to lunch tonight:
SELECT * FROM WEEKS WH
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:0
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 <=
om: Micah Stevens [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 13, 2005 9:13 PM
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB] Question on CURDATE()
>
>
>
> What SQL server are you using?
>
> On Tuesday 13 September 2005 7:08 pm, reclmaples wrote:
> > I am t
I am using mysql Ver 12.22 Distrib 4.0.16
Sorry for not including that.
Thanks
-Rich
-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 9:13 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Question on CURDATE()
What SQL server are you
What SQL server are you using?
On Tuesday 13 September 2005 7: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
> s
