Heres an easy one?

[luckyblackcat]

I have a table cart. Using PHP ....

I want to DELETE a row where username = $username AND item_no = $item_no

I have the code ..

$query = "DELETE FROM cart WHERE username = $username AND item_no = $item_no LIMIT 1";
mysql_query($query);

It doesn't work,
anyone know why???

Thanks for reading this

 

[danielhozac]

You have to put the strings within quotes. Try using

$query = "DELETE FROM cart WHERE username = '$username' AND item_no = '$item_no' LIMIT 1";
mysql_query($query);

instead. //Daniel