Trunicating log enteries after 24 hours

[boionfire81]

Using mysqli timestamp, and mccodes time() function, combined with a minute cron, is it possible to run a query to delete logs over 24 hours?

The time functions I still have not learned yet.

[TheMasterGeneral]

$Time=time();
$DeleteTime=$Time-86400; //86400 is 24 hours
$db->query("DELETE FROM `table` WHERE `timestamp` <= {$DeleteTime}");

 

[boionfire81]

TY! Needed that :)

[Magictallguy]

This can also be done as just the query

$db->query('DELETE FROM `table` WHERE `timestamp` <= (unix_timestamp() - 86400)');

 

[Sim]

Retarded to add that in a minute cron. I would use a daily cron personally. No less then a hourly cron.