I'm building a music site with gig listings, but I need to be able to do a script to delete listings with yesterday's date without having to use mysqlAdmin or like to do it manually. Any suggestions? eg "DELETE * FROM gigs WHERE date='yesterday'"
What you can do is to write a perl or PHP script, and put it in the crontab of your server (if it's a unix/linux server). If you write it in PHP simply use wget (shell program) to trigger the script ;-)
wget, or get yourself a CGI version of PHP. That's probably easier to use, and doesn't load your webserver, and it can run using different privileges (like root)
