Delete

[Anon]

Hi, i'm trying to delete a file from a mysql database. I can get it to delete from this table however, if there is two items both with the same name, then it deletes both of them, i want it to delete by selecting the $serviceno and the $details however i can't get it to work

$query = "DELETE FROM lambitems WHERE name = '" . $detail . "'";

any help would be great,

thanks.

[Anon]

Try this: "DELETE FROM lambitems WHERE name = '$detail' AND serviceno = '$serviceno'"

That should work...

Andreas Bernhardsen

[Anon]

thanks it works great now