How to delete things that are three days old?

[Petraverse]

Hi all,

I have a table in my MySQL db and one of the columns is a DATE column and in it I just use NOW() and it puts something alone the lines of 2004-08-28. What I ant to do is write a script that deletes everything 3+ days old but really don't have any idea how to go about this. Any ideas?

Thanks
Max

[LordShryku]

$sql = "DELETE FROM table
         WHERE date_field <= '".date("Y-m-d", strtotime("-3 days"))."'";
mysql_query($sql);

Just run it from cron...