[Bazzio]

Hey
I have a gig guide on my site
the date is store as MM.DD.YY in event_date in MySQL table

when the date has past, i want to have the old gigs deleted automatically

Can anyone help me out??
Thanks!!
Andy

[xtremenw]

Originally Posted by Bazzio

Hey
I have a gig guide on my site
the date is store as MM.DD.YY in event_date in MySQL table

when the date has past, i want to have the old gigs deleted automatically

Can anyone help me out??
Thanks!!
Andy

Mysql does not have anything like that built it... The closest thing would be to build a stored procedure and a trigger... But that would only work in MySQL5... You could build a scheduled task (Windows) or a cron job (Unix) to just run the following query at 12:01am everyday. 'DELETE FROM $table WHERE date_stamp < NOW();'

[Bazzio]

is there a way i can use php to not display the dates that have passed instead?

[xtremenw]

Originally Posted by Bazzio

is there a way i can use php to not display the dates that have passed instead?

Absolutly! In your SQL statement, just include in the WHERE clause 'date_scheduled > curdate();'

Hope that helps...