Remove on date
I am making a MySql database to manage events. People who submit events will be able to put in on what date the event is taking place.
Is there something I can do that once the event has passed ie. the date of the event has passed the event doesn't show on the site anymore. I would like to make this automatic.
What would be the best way to do this.
Compare event date and now() in the sql query you use to select events to show on the site?
How to compare date
Could you please tell me how to compare the date using CURRENT_DATE( ) .
Last edited by indiaoz; Jun 2, 2003 at 05:59.