|Monte on Oct 23, 2009 at 2:30:54 PM (# 1)|
What DB are you using?
Is there a TODAY()?
Or maybe it's a formatting issue with the date.
How is events.eventDate formatted compared to NOW()?
Jockrock on Oct 23, 2009 at 3:58:20 PM (# 2)
This message has been edited.
Database is MySQL using PHP event date formatted yyyy-mm-dd. Aha - OK I got it! I am new to MySQL and never realised it has a function CURDATE() - That fixed the issue. Thanks for input!
Terry Young on Oct 29, 2009 at 10:46:16 AM (# 3)
It's interesting, to think of it now, that I never knew nor used CURDATE() for all these years. I simply rely on PHP or ASP or whatever, and inject the date literal into the SQL statement.
Jockrock on Oct 30, 2009 at 5:35:49 PM (# 4)
I am living testament to the lie that states you can't teach an old dog new tricks!