Deleting old MySQL rows?

[WebCheez]

How would I make a script that would delete any row in a MySQL table that was more than 7 days old?

[mikesta707]

do you have a column in your table that is a timestamp of when the row was entered? if so is it a date or datetime type?

[WebCheez]

Nope. *goes to create one*

[WebCheez]

So once I have that, what do I do?

[Drummin]

Something like this

$timeoutseconds = 604 800;
//get the time
$timestamp = time();
$timeout = $timestamp-$timeoutseconds;
$delete = mysql_query("DELETE FROM mytable WHERE timestamp<$timeout");