I'm sure this is a pretty simple question, but I can't think of a solution at the moment. I'm trying to update a decimal value, based on the current value of the field.
I want to reduce the amount in the field by the amount in a variable... something like this...
"currentrequest" is the current field... So, basically I want to update current request to be it's current value minus 100.00.
I've tried using a select subquery in there, and it tells me that I can't select the same table...
The error I receive is: "You can't specify target table 'budget' for update in FROM clause".
Thanks for any shoves in the right direction!
WHERE acct='".$acctNum."' LIMIT 1");