[SOLVED] Delete rows, older than the current day?

[spikypunker]

Hey duuudes, i've got a mysql which holds an events section of my site, at the moment i log in each day and delete all entries with a date older than the current date, but yeah, i need this to be automatic really. I've set up a CRON on the server, which runs cron.php at 3 in the morning each day. In this php page i've got the following code....

 

<?
$date = date("Y-m-d");

mysql_connect ("localhost","###","###");
@mysql_select_db("###") or die ("unable to connect");

$query = "DELETE FROM events_backup WHERE 'date' < $date ;";

$result = mysql_query($query); 

mysql_close();

echo "$date ";
?>

 

I thought this would be fairly simple but alas, i've tried it on my back up table (events_backup) and it deleted all the data!

 

poo

[GingerRobot]

You've put single quotes around your field name. Therefore, it's treated as a string. Lexicographically, 'date' must be less than any number, therefore, it's deleting all the rows since it's true for all rows.

[spikypunker]

haha my fault, simple error, should have checked!

 

<?
$date = date("Y-m-d");

mysql_connect ("localhost","maddogma_listing","mightyb00sh");
@mysql_select_db("maddogma_listings") or die ("unable to connect");

$query = "DELETE FROM events WHERE date < '$date' ;";



$result = mysql_query($query); 

mysql_close();

?>