Re: mysql - php DATE QUESTION...
| From: | _lallous | Date: | Fri, 05 Oct 2001 12:00:51 +0000 |
| Subject: | Re: mysql - php DATE QUESTION... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13035@lists.php.net to get a copy of this message | ||
DELETE FROM tablename
WHERE DATE_SUB(tablename.datefield, INTERVAL 30 DAY) > NOW()
"Koutsogiannopoulos Karolos" <k.koutsogiannopoulos@ideal.gr> wrote in
message news:9FF400760CD3D311B3B000A0C9D440BC96894C@exchange.internal...
> Can someone offer some help...?
>
> Lets say i have a date collumn in a mysql table that includes dates that
get
> stored each time i enter an entry...
>
> How can i check when i enter the page that displays the entries to delete
> all entries older than 30 days?
>
> thanks.
>