DELETE where time 5 minutes ago?

[tjhilder]

I've created an online users script, the inserting and updating works fine, just need to delete the entries that are inactive before 5 minutes ago.

here's my code.

[code]
$delete_lookup = "DELETE FROM v3_usersonline WHERE time='<= " . $five . "'";
if (!$delete_lookup_result = mysql_query($delete_lookup))
{
    echo "nothing deleted because : " . mysql_error() . " the query was: " . $delete_lookup;
}
else
{
    echo "";
}
[/code]

[wickning1]

DELETE FROM v3_usersonline WHERE time < NOW() - INTERVAL 5 MINUTE

[tjhilder]

thanks for your help, i've managed to fix it.