How to delete 3 months old records in my database?
[email protected] (Karl-Arne Gjersøyen)
| Newsgroups | php.general |
|---|---|
| Message-ID | <CAN78Z6CaA_1cjBQB1Dfa=tOQtBSC9c=sAsCZ98UXz7ob=hNLmQ@mail.gmail.com> |
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