delete time related data inside a table within 1 hour

[Mark-Walter@xxxxxxxxxxx]

Hello,

to delete old entries within 1 one day I use this:

$sql = ("DELETE FROM orders WHERE time_date < DATE_ADD(NOW(), INTERVAL
-1 DAY)");

Now I would like to delete within a timeframe of 1 hour.

But when I change the above statement to 1 hour or -1 hour it deletes 
immediately.

Maybe someone could help me at this point.

-- 
Best Regards,

Mark

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