update calcs

wxdqz

New Member
Would somebody please help me with this? I think the problem is in the expression (maybe some sort of quotation or bracketing) but I can't work out where.

$set = "SET qtos52 ='".(qtos52 - $orderqty[$count])."' ";

When used in the update, if qtos52 is 100 and $ordertqy is 1 I expect qtos52 to become 99.
Instead it comes out as -1

Any ideas?

Thanks

Chris
 
Back
Top