delete mysql rows 3 days old

[The Little Guy]

I need to delete rows from a database if the activation code has not been saved, and is over 3 days old.

If the activation code has been saved, then ignore it, and don't delete it.

[paul2463]

First off ASSUMPTION:
The date they joined was set up in the database and it is as a normal sql date ( 25-11-2006)

[code]
$today = strtotime("Now");
$3day = strtotime("- 3 day" , $today);
$deletedate = date("Y-m-d", $3day);
$query = "DELETE FROM (table) WHERE activation is (NOT active) AND date < '$deletedate'";
mysql_query($query) or die ('Error in query: $query. ' . mysql_error());
[/code]

[The Little Guy]

what does [b](NOT active)[/b] mean?

[The Little Guy]

Nevermind... I got it.