Re: [PHP-DB] DELETE mySQL query

On Aug 16, 2009, at 12:23 AM, "Ron Piggott" wrote: Is there a way to do the math in a DELETE statement (All 1 step; See my "sample" below pseudo code below). I am trying to delete the record if it is more than 3 hours old and the value of "approved" is still 0. DELETE FROM `guest_b

[PHP-DB] DELETE mySQL query

Is there a way to do the math in a DELETE statement (All 1 step; See my "sample" below pseudo code below). I am trying to delete the record if it is more than 3 hours old and the value of "approved" is still 0. DELETE FROM `guest_book` WHERE `guest_book`.`date_submitted` + 3 hours =< '$current

[PHP-DB] DELETE mySQL query

Is there a way to do the math in a DELETE statement (All 1 step; See my "sample" below pseudo code below). I am trying to delete the record if it is more than 3 hours old and the value of "approved" is still 0. DELETE FROM `guest_book` WHERE `guest_book`.`date_submitted` + 3 hours =< '$current