How to delete 3 months old records in my database?

[Karl-Arne Gjersøyen]

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

[Dušan Novaković]

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

Post by Karl-Arne Gjersøyen
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

[Karl-Arne Gjersøyen]

Post by Dušan Novaković
$query = "DELECT FROM `__table_name__` WHERE `__date__` BETWEEN NOW() -
INTERVAL 3 MONTH AND NOW()"

This delete everything from now and 3months backwards. I want to store 3
months from now and delete OLDER than 3 months old records.

Karl

[Simon Schick]

Post by Karl-Arne Gjersøyen

Post by Dušan Novaković
$query = "DELECT FROM `__table_name__` WHERE `__date__` BETWEEN NOW() -
INTERVAL 3 MONTH AND NOW()"

This delete everything from now and 3months backwards. I want to store 3
months from now and delete OLDER than 3 months old records.
Karl

Hi, Karl

You're right, but restructuring, to get it the way you want, isn't be
that hard, is it? :)

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

@Dusan,
Btw: What is "DELECT"? I assume it should've been "DELETE", right?

Bye
Simon

[Dušan Novaković]

Yeah, just spelling mistake :-)
And yes, it should be:

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


Cheers ;-)

Post by Simon Schick

Post by Karl-Arne Gjersøyen

Post by Dušan Novaković
$query = "DELECT FROM `__table_name__` WHERE `__date__` BETWEEN NOW() -
INTERVAL 3 MONTH AND NOW()"

This delete everything from now and 3months backwards. I want to store 3
months from now and delete OLDER than 3 months old records.
Karl

Hi, Karl
You're right, but restructuring, to get it the way you want, isn't be
that hard, is it? :)
$query = "DELETE FROM `__table_name__` WHERE `__date__` < NOW() -
INTERVAL 3 MONTH"
@Dusan,
Btw: What is "DELECT"? I assume it should've been "DELETE", right?
Bye
Simon
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[Simon Griffiths]

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

Post by Karl-Arne Gjersøyen
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

[Jim Giner]

Post by Karl-Arne Gjersøyen
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

So close! BUT - you need to reverse your test.

where date <= '$old_records_to_delete'