How to delete 3 months old records in my database?
| From: | Karl-Arne Gjersøyen | Date: | Fri, 02 Aug 2013 10:58:41 +0000 |
| Subject: | How to delete 3 months old records in my database? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-321757@lists.php.net to get a copy of this message | ||
Hello again, folks!
I wish to delete records in my database that is older than 3 months.
$todays_date = date('Y-m-d');
$old_records_to_delete = ???
if($old_records_to_delete){
include(connect.php);
$sql = "DELETE FROM table WHERE date >= '$old_records_to_delete'";
mysql_query($sql, $connect_db) or die(mysql_error());
}
Thank you very much for your help to understand also this question :)
Karl