OK
I got the example to work and it does add all the numbers,
except I can only get the query to work inside
PHPMyADMIN
Placing the query inside PHP webpage where I run similiar queries on the same table outputs
Parse error: parse error, unexpected '='
This really is starting to get crazy, I have followed exact same query structure as the queries that do work...