How to delete old records in my MySql database?

Question

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());
}

Answer 1

$query = "DELETE FROM __table_name__ WHERE __date__ < NOW() - INTERVAL 3 MONTH"

Answer 2

$query = "DELETE FROM __table_name__ WHERE __date__ BETWEEN NOW() - INTERVAL 3 MONTH AND NOW()"

Answer 3

Try something like:

$oldDate = new DateTime();
$oldDate->sub(new DateInterval('P3M'));
$old_records_to_delete = $oldDate->format('Y-m-d');