Posted by trawets on 11/08/07 21:25

Hi
I am trying to write something which will enable me to run a php
script from cron which will delete news item entries from a mysql db.

Criteria here is that the script would look at a field 'publish_down'
which has this format '2007-01-29 16:00:08' check this date is passed
and then delete if it is more than 90 days older.


I have tried to come up with something but a little advise would be
grateful


$today = date("Y-m-d", publish_down("-90 days"));


mysql_query("DELETE FROM table WHERE date = '$today'") or
die(mysql_error());

(publish_down = a table field which is a date)

how would I adopt this type of query into php script


please
trawets

[Back to original message]