Hello-
I'm running MySQL and php and when I run the query below I don't get any
return rows.  As you can see I search for events that are happening between
a certain date.  The "startDate" field is type DATE in MySQL and the date in
the database that should be returned in "2001-03-27" but I'm not getting any
results.

select * from events where startDate>='2001-03-01' and
startDate<'2001-01-04'

Any help on what I could be doing wrong would be great!

Thanks,
Jay Paulson
Developer, Web Technologies
Viatel, Inc.
http://www.viatel.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to