On Aug 16, 2009, at 12:23 AM, "Ron Piggott" <ron....@actsministries.org> 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_book` WHERE `guest_book`.`date_submitted` + 3 hours =< '$current_time' AND `guest_book`.`approved` = '0' LIMIT 1

Check out the timediff function in mysql's SQL



Sent from my iPod

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to