Re: Autodeleting news when it has become yesterdays news
| From: | Matt Stone | Date: | Wed, 23 Nov 2005 13:50:16 +0000 |
| Subject: | Re: Autodeleting news when it has become yesterdays news | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-226349@lists.php.net to get a copy of this message | ||
----- Original Message -----
From: "twistednetadmin" <twistednetadmin@gmail.com>
To: <php-general@lists.php.net>
Sent: Wednesday, November 23, 2005 7:02 AM
Subject: [PHP] 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