Summing columns

[cpd]

Say for example i have a table in my database like this:

 

id    value

1      5

2      6

3      1

4      8

 

And i want to total the "value" column. How do i sum it and is it a function like mysql_num_rows()?

[sasa]

use SUM() function in SQL

[cpd]

Will that not just get the amount EG in this case 4 because theres 4 rows.

 

I want the sum of the values in each row not the amount of rows?

[premiso]

Will that not just get the amount EG in this case 4 because theres 4 rows.

 

I want the sum of the values in each row not the amount of rows?

 

Umm no...

 

SELECT SUM(value) as valueSum FROM tbl_name WHERE ID IN(1,2,3,4) GROUP BY value

 

Will return valueSum = 20

 

 

[Mark Baker]

Will that not just get the amount EG in this case 4 because theres 4 rows.

 

I want the sum of the values in each row not the amount of rows?

It will return the sum.

That's why the function is called SUM()