Hi, I was wondering if it was possible to update the value of a mySQL cell by a method similar to using += in php code. For example, I'd like to do:
$sql = "UPDATE inventory WHERE userID = '$_SESSION[userID]' SET money+='$ssmoney'";
I know I can instead run another query to get the db values, then add the db values to new values, and then run an update query, but I was hoping there was a simpler, more-efficient way. Thanks.