Adding values from different sets?

[SC__Programmer]

I have a users table and every user has  points.so i want to add the points from all the user sets.

 

So like theres a id,username,password,email,and points in a set.i want to add all the points together to share on the site stats

[The Little Guy]

select sum(points) as points from my_table;

[fenway]

I still prefer a WHERE clause and a GROUP BY, just so it won't be useless later on.

[SC__Programmer]

when i tryed it,it came back with "Resource id #22"...

 

i used this code,

$points = mysql_query("select sum(points) as points from tb_users");

 

what am i doing wrong?

[The Little Guy]

$points = mysql_query("select sum(points) as points from tb_users");
$row = mysql_fetch_array($points);
echo $row[0];

[SC__Programmer]

Thanks