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.
Advertising
DELETE FROM `guest_book` WHERE `guest_book`.`date_submitted` + 3 hours =< '$current_time' AND `guest_book`.`approved` = '0' LIMIT 1
