can anyone tell me please why this will not work:-
UPDATE matchstats SET posspread = abs(homepos, awaypos)
Nope, need more of the code in php tags to diagnose.
Might have something to do with too many variables. abs takes a single value, not a list of several.