Problem with datetime SELECT

[cyphix]

Could anyone tell me why this isn't returning a row with a date (date_held field data type = date) value of '2009-05-11' ?


SELECT title,venue,address,phone,time,price,website,description FROM events WHERE business_type=1 AND (day='monday' OR date_held='2009-05-11') ORDER BY recurring ASC, id DESC


Thanks!

[CFMaBiSmAd]

Is business_type=1 in the row that you expect to be returned?

[cyphix]

Yeah.. I realized that after I turned the PC off for the night.... that was it...... I'm such an idiot LOL!! :rolleyes:

[Fumigator]

It's usually the simple stuff that snags ;)