Union of numbers inside a MYSQL table

[bnashenas1984]

Hi everyone
I need to retrieve the union of numbers in a MYSQL table with PHP
Here is an example:

+--------+---------+
| users  | points  |
+--------+---------+
| David  |     10  |
| Peter  |     18  |
| John   |     23  |
+--------+---------+

And what I need is to get 51 which is 10+18+23


Thanks / Behzad

[r035198x]

Read about the SUM function.

[bnashenas1984]

Hi
And thank you r035198x
You are a life saver

THANKS AGAIN its working now.