Selecting the TOTAL in a field

[Pests]

I have a counter for each page:

id|page|count

I need a SELECT to get a the total number of count's for every page, for example:

id|page|count
1|index.php|100
2|main.php|11
3|login.php|3

I need it to return the 123 (100+11+3). I need this to be in SQL (and not a PHP add up script) cause its going to be called alot.

[zone16]

try

select sum(count)
from my_table

la'ers,

zone16

[Frederick]

$sql = mysql_query("SELECT sum(count) FROM tablename")
or die(mysql_error());

echo mysql_result($sql,0,0);

[Pests]

Thanks, I was searching MySQL for something like TOTAL.