On 8/2/2013 6:58 AM, Karl-Arne Gjersøyen 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
So close! BUT - you need to reverse your test. where date <= '$old_records_to_delete' -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
