I have a table that i am using to kep track of user items,
in the check out process they might want to remove one of these items.
I had a clear all that worked fine but for some reson I can get it to delete with one item.
the two fields that i are important are a user_id and sel_item.
So I am trying to decide if my SQL syntax is way off.
I thought somehitng like
$query = "DELETE FROM table_name
WHERE user_id =\"$user_id\" AND sel_item = \"$sel_item\"";
By the way I am sending the sel_item variable through the browser and the user_id is from a cookie.
thanks in advance
in the check out process they might want to remove one of these items.
I had a clear all that worked fine but for some reson I can get it to delete with one item.
the two fields that i are important are a user_id and sel_item.
So I am trying to decide if my SQL syntax is way off.
I thought somehitng like
$query = "DELETE FROM table_name
WHERE user_id =\"$user_id\" AND sel_item = \"$sel_item\"";
By the way I am sending the sel_item variable through the browser and the user_id is from a cookie.
thanks in advance