Sum all fields of an array?

Tracer

I have an array of returned results from an ODBC querry

myarray(RECORD1)[Field1][Field2][field3]
myarray(RECORD2)[Field1][Feld2][field3]
myarray(RECORD3)[Field1][Field2][field3]
etc etc

I need to total [field1] and store it to a var, then total [field2] and store it into a seperate var, etc etc.

Is there an easy way of doing this rather than creating a while loop and parsing through the entire array record by record and addign to a var?

There is an array_sum function but it doesn't seem to work or work as docuemnted.

diego25

array_sum does work as documented. It's your dataformat that isn't compatible with array_sum. To make it compatible, you need to transpose the array...but if the array is big, I wouldn't suggest transposing.

Another way would be to use SQL:

SELECT SUM(field1), SUM(field2), SUM(field3) FROM table

but you can only use that if you don't want the individual elements of the query...or you don't mind having a second SQL query.

Another method would be to use loops. Why don't you want to use this method?

Diego

Tracer

The array is the returned set from an odbc query, not MySql, I will check to see if there are any odbc sum field commands.

The array will have between 5,000 and 15,000 keys.

There are about 6 fields within the array which need to be summed.

diego25

The SUM() function standard SQL, so it should work on all SQL databases.

If you have that many rows, then I'd recommend either using SQL's SUM() or loops. (And you didn't tell me why you didn't want to use loops 🙂 )

Diego

Tracer

DUH.....Not Thinking, must be superbowl flu.....

Of course I can use SELECT SUM, SELECT AVG, SELECT MAX......

I had it in my head that ODBC= NO SQL......

What do you think would benchmark better. Doing mutliplt select AVG and Select SUM odbc querries (faircom c-tree db) or 1 querry and looping through the returned array?

diego25

I don't know, but you can time it yourself using microtime() (PHP function, not SQL)

Diego