Ok well as I said the best would be to run a script in cron. If php is installed as a cgi module then just create a file in cron.daily php checkDatabase.php
if its not you can do a little tricka and say
lynx checkDatabase.php > /dev/null
(This is all under Unix type enviroments.. I am not sure for windows).
Then just have the script:
<?php
// Query database to return the date field of ever row and put it into an array say blah[]
// then just
// Get todays date
$now = date("Y-d-m",time());
$rDate = explode("-",$now);
$rYear = $rDate[0];
$rDay = $rDate[1];
$rMonth = $rDate[2];
for($i = 0; $i < sizeof($blah);$i++) {
$row = $blah[$i];
$rowArray = explode("-",$blah[$i]);
$year = $rowArray[0];
$day = $rowArray[1];
$month = $rowArray[2];
if($year < $rYear || $day < $rDay || $month < $rMonth) {
..... Query the database to find out where the date field is at $row (which should be some number like 2000-19-1 ) and tell the database to delete all the entries like this one (In mysql:
$query = "Delete FROM $table where Date = '$row'";
MYSQL_QUERY($query);
)
}// end if
}// end for
That should do it! Just a warning I havent tested this code and there might be some conditions where it doesnt work.
Good Luck!
