[SOLVED] how do i not show old dates on events list

[i-fm]

I've spent a fair bit of time looking around other posts looking for answer to this one and couldnt really come up with anything.

 

I have an events list.  shows it by date - (this field is called sdate saved in mysql using date)

 

at the moment it shows everything in the database,  but what i want it to do is not show any old dates (records)... i only want it to show upcoming dates and not past dates.

 

 

thanks in advance

dave

 

 

 

[shocker-z]

Try this mate

 

 

SELECT * FROM events WHERE sdate > CURDATE() order by sdate ASC

 

Regards

Liam

[i-fm]

Liam

 

Thank you,  works perfect....  couldnt ask for a simplier or quicker fix.

 

Cheers

Dave