mysql Delete

[ghornet]

this statement will echo "deleted" but it does not actually delete from the database... any ideas?

$done = mysql_query("DELETE FROM $table WHERE 'item' = '$item' and 'date' = '$date'");
if ($done) {echo "Deleted";}
else {
echo("Error: " . mysql_error());
}

[Anon]

That just means the query was successful. Try this.

$done = mysql_query("DELETE FROM $table WHERE item = '$item' and date = '$date'") or DIE("Error: ".mysql_error());

if(mysql_affected_rows($done))
{
echo "Deleted";
}
else
{
echo("Error deleting data");
}

[ghornet]

why won't the delete statment work?

[Anon]

I don't know, why don't you change it to this and copy and paste the query to your mysql interface to see why.

$q = "DELETE FROM $table WHERE item = '$item' and date = '$date'"
print $q;
$done = mysql_query($q);

[ghornet]

thank you for your help so very very much...