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?

Cheers
LVL 1
PhilJMcDougallAsked:
Who is Participating?
 
divstarCommented:
This would be the CURDATE() function

For example - SELECT * FROM tourdates WHERE date >= CURDATE()
0
 
PhilJMcDougallAuthor Commented:
Managed to figure it out anyway with a NOW() but your one also works.
0
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.