hi,
I want to update a selected fields in a database, the information i want to update comes from a form but i want it to decrease the value. What i mean is:
The user inputs how many of a product they want and i want the stock field in the database to decrease by that many, any help?
This is the current code im using but it increase the value not decrease.
I want to update a selected fields in a database, the information i want to update comes from a form but i want it to decrease the value. What i mean is:
The user inputs how many of a product they want and i want the stock field in the database to decrease by that many, any help?
This is the current code im using but it increase the value not decrease.
PHP:
$quantity = $_POST['quantity'];
$sql = "Update item (Stock) VALUES ('$quantity')";
$result = mysql_query($sql) or die ( mysql_error() );?>
Last edited: