php code to delete by date

Anon

i have a mysql field called expired of type date in a table that holds the date that the record needs to be expired. what php code would i need to delete all records that if the date in the expire column for each row was older than current date.

Anon

I haven't tried it, but you should be able to use a mysql command and tack on $thedate which would be the current date in the same format as the dates in THEDATECOLUMN.

DELETE from TABLENAME where THEDATECOLUMN is less than $thedate

I would <i>think</i> that mysql is smart enough to figure out what you mean.

(backups of databases are a good idea!)

harlan

If this doesn't work, you might want to try

$formatteddate = "2001-01-12";

DELETE FROM yourtable WHERE DATECOLUMN < '$formatteddate'

Anon

would CUR_DATE() work for the current date?

Anon

i think in mysql it's CURDATE(), but yeah... if CUR_DATE() is another name for the same function, that should be fine.

Anon

would this by the proper php code?

$result = mysql_query("SELECT * FROM AD WHERE expires < $thisdate",$db);

Anon

$thisdate will expand into a literal string without any quotes around it. put ''s around $thisdate

$result = mysql_query("SELECT * FROM AD WHERE expires < '$thisdate'",$db);