[SOLVED] select date today or in future

[brown2005]

SELECT * FROM events ORDER BY events_date ASC

 

is what I have at the moment, but I want to change that to only include dates today and in the future..

 

[gevans]

What field type  is events_date?

[brown2005]

What field type  is events_date?

 

date

[gevans]

SELECT *
FROM `events`
WHERE CURDATE() <= `events_date`
ORDER BY `events_date` ASC;

 

That should do the trick

[brown2005]

SELECT *
FROM `events`
WHERE CURDATE() <= `events_date`
ORDER BY `events_date` ASC;

 

That should do the trick

 

thanks very much...