Get the sum of each field

Jon7800

Good morning!

Could someone please help me with getting the sum of each field? I have 5 values to sum up and I can't seem to get it. This is what it looks like in phpMyAdmin:

id employeeName v1 v2 v3 v4 v5

1 J Landry 10 1 1 18 7

2 J McDoug 0 20 8 5 9
3 C Kanest 10 10 10 10 10
4 G Farrel 10 30 20 10 10
5 H Johnson 15 10 11 12 11

I would like the sums of v1, v2, v3, v4 and v5.

Thank you!
-Jon

Drakla

Left to right, or top to bottom?

As in the sum of all v1 columns, or for each row the sum of v1 + v2 + ...

Jon7800

the sum of all v1, all v2, etc...so top to bottom

devinemke

SELECT SUM(v1), SUM(v2), SUM(v3), SUM(v4), SUM(v5) FROM table

Roger_Ramjet

You need GROUP BY and Aggregate Functions , specifically SUM

$sql = "SELECT SUM(v1) as Sv1, SUM(v2) as Sv2, SUM(v3) as Sv3, SUM(v4) as Sv4, SUM(v5) as Sv5 FROM table GROUP BY v1, v2, v3, v4, v5"

The 'GROUP BY v1, v2 ...' is not strictly required by MySQL because of it's sloppy SQL syntax. It is with most other SQL dialects used by other DB engines so it is a good habit to get into if you want portable code and transferable skills.

Jon7800

and then to display the data, how do I create a variable for each of the "v" fields?

Jon7800

It's Resolved. Thank you very much!