I have a problem with getting error on update...
What i have is - one table where i store my orders, and one table where i keep stock records. I managed to update the stock in my table with this piece of code but when i have for example 5 products in stock and i place order of 10, my stock goes -5 which is no gud :) How can i change that?
$sql="update parts set quantity=quantity-".$values["quantity"]." where part_number='".$values["part_number"]."'";