On Aug 16, 2009, at 12:23 AM, "Ron Piggott"
<ron.php@xxxxxxxxxxxxxxxxxx> 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
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff
Bastien
Sent from my iPod
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
