Show only records that occur after todays date

Hey guys, having a bit of trouble finding out the code i need so that i only display the records after todays date in a mysql statement. I know its a WHERE command but i cant seem to get it to work.

Basically i have a table for some tour dates and i want the page to only display the dates after & including today only. Then on another page have all the dates that occurred before todays date.

Anyone know the code for the statement?

Who is Participating?
This would be the CURDATE() function

For example - SELECT * FROM tourdates WHERE date >= CURDATE()
PhilJMcDougallAuthor Commented:
Managed to figure it out anyway with a NOW() but your one also works.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.