RE: [PHP-DB] Delete by date?
| From: | John W. Holmes | Date: | Mon, 09 Dec 2002 03:55:36 +0000 |
| Subject: | RE: [PHP-DB] Delete by date? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23916@lists.php.net to get a copy of this message | ||
> How would I do that? I just did this:
>
> $date = date("Y-m-d");
>
> and changed my date field in my MySQL DB to use the Date format, I
don't
> know if that's correct though? Then how would I get to delete all
before
> the current date?
DELETE FROM table WHERE date_column < CURDATE()
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/