> You are missing a " before $booktitle.
> old:booktitle=$booktitle AND quantity=quantity";
> new:booktitle="$booktitle AND quantity=quantity";
So you're saying
$sql = "UPDATE Book2 SET stock ='$stock-quantity' WHERE
booktitle="$booktitle AND quantity=quantity";
is the correct SQL statement? Me thinks you would be mistaken. That's
another painful parsing error waiting to happen. You are partially right
though, quotes were missing from the statement (although the missing quotes
would have no effect on PHP running the code, just the MySQL server trying
to execute the query).
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php