Hi I have looked around to see if it is possible to automatically delete records with a date field once that date is in the past. Everything I have found just gives the script but you would have to run it every day. Is there a way to have it set up so it runs itself every day?
Thanks
Gilgil
Jump to PostHave a look at mysql events.
http://dev.mysql.com/doc/refman/5.1/en/events.html
Use a cron job. If you are on a windows platform (I am) I'd recommend Windows Cron Service by Intelladmin http://www.intelliadmin.com/?p=5079
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.