----- Original Message ----- From: "twistednetadmin" <twistednetadmin@xxxxxxxxx> To: <php-general@xxxxxxxxxxxxx> Sent: Wednesday, November 23, 2005 7:02 AM Subject: Autodeleting news when it has become yesterdays news >I have a news-script on a webpage. Or an eventscript you might call it. >This lists up events thats gonna happen on a given day. ie concerts and >sportsevents. >To get this deleted without having to log on to the adminpage when the event >s over would have been a great relief. >1. Is it just as simple as writing a query that executes and removes news >with yesterdays date? Yup, DELETE FROM your_table WHERE date_column = curdate() -1; Cheers Matt -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
