Hey guys,
I am trying to update the Quantity field in my database on button click. I have a checkout system, and on the final checkout page it displays my basket items in a listview bulleted list.
Now say there is 1 item, and the quantity is 5, upon the purchase button I want my stock table to be updated to have 5 less in the quantity field.
Cant seem to work out how to do this, as there are no labels or textboxes, just the listview so unsure how to word the SQL query.