$query = "DELECT FROM `__table_name__` WHERE `__date__` BETWEEN NOW() -
INTERVAL 3 MONTH AND NOW()"
On Fri, Aug 2, 2013 at 12:58 PM, Karl-Arne Gjersøyen <karlar...@gmail.com>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 = ???
> $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 :)
mob: + 46 7 230 230 19
Please consider the environment before printing this email.