----- Original Message ----- 
From: "twistednetadmin" <[EMAIL PROTECTED]>
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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to