Delete from a Mysql Database via Date

[djcomplex]

i thought it was a fairly straight forward script to write which would check thro a database and check 1 date against CURDATE() if it is less that CURDATE() the record would be deleted however it doesnt seem to to work.

$query = "DELETE * FROM tblname WHERE date_due < CURDATE()";
$result = mysql_query($query);

i thought that would do it

i even tried adding
echo mysql_affected_rows();
after but all it returned was -1 and the record stay there

can anyone help?

[bad76]

Hi,
for me all this sound good...

I've tried with date and timestamp field, all work fine.

I suggest you to echo mysql_error() after the query. May be you get some other info on this error...

see you

[AshtrayWaterloo]

Instead of "DELETE * FROM" try "DELETE FROM". Might do the trick for you.

Ash

[djcomplex]

working now 😃