[SOLVED] Delete Entries 1 week old or older.

[techiefreak05]

I have a query that's supposed to remove bulletin entries that are a week old and over, but its not working, and the "date" column is filled with "time();"

 

<?php
mysql_query("DELETE FROM `bulletins` WHERE `date` > (time() + (3600*24*7))");
?>

[lightningstrike]

perhaps this...

$value = time() - (3600*24*7);

mysql_query("DELETE FROM `bulletins` WHERE `date` < " . $value . "");

[techiefreak05]

thanks a lot.

it worked.

:-)