Destroy Dates on MySQL Files

[cdherold]

fellow php'ers,

Is it possible to put a destroy date on a MySQL file?

If I have the date that I want to be the destroy date in date_field, using the MySQL date format 0000-00-00, how do I go about making sure that the entire file is deleted on that day?

thanks,

cdherold

[brandonschnell]

run a crontab job with the mysql sql script "DELETE FROM table WHERE date_col = NOW()"

[cdherold]

--
need more info ... like what is a crontab job? I tried putting the call into my code, but it didn't seem to work.

Does this look right?

<?

$db = mysql_connect("db.local.com", "$user", "$pass");

mysql_select_db("$database", $db);

mysql_query("DELETE * FROM events WHERE finish = NOW()",$db);

$result = mysql_query("SELECT * FROM events ORDER BY finish",$db);

if ($myrow = mysql_fetch_array($result)) {

do {

printf("<font style=times size=4>");

printf($myrow["event"]);

printf("</font><br>");

} while ($myrow = mysql_fetch_array($result));

} else {

echo "No Events Are Currently Listed";
}

?>

[kparker]

mysql_query("DELETE * FROM events WHERE finish = NOW()",$db);

That's not likely to delete very many items, since it requires an
exact match of the time. You'll have better luck saying

... WHERE finish <= NOW()