Re: [PHP] How to delete 3 months old records in my database?

Hello,

Try something like:

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


Hope this helps,

Si

Sent from my iPhone

On 2 Aug 2013, at 11:58, Karl-Arne Gjersøyen <[email protected]> wrote:

> 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