How to use php to delete mysql logs 3 hours old

[plznty]

basically could somebody help me with information on having a php script that deletes mysql rows which are older than 3 hours old.

I know MYSQL table will need a date/time column but how can I only target ones which are 3 hours old+.

Thanks

[Yucky]

You could store a Unix timestamp with every record and then do something along the lines of:

define("EXPIRY_TIME", 10800); //Three hours in seconds
$deleteTime = mktime() - EXPIRY_TIME; //Delete everything created before this timestamp
$query = mysql_query("DELETE FROM `logs` WHERE `timestamp` < $deleteTime");