Sum()

[Anon]

Hi Dudes!

I have a trivial problemn and i hope that i get help here ;-)

I have a mysql table with a field called count.
There are many entrys with different numbers in the filed count.
Now i want count all these fields together and make an echo with the result.

Can someone help me?

I tried this one:

select sum(count) from table1

and try to read $count but this is not working.

Thank u a lot and greeetz from mike

[cheald]

$sql = "SELECT sum(count) as count FROM table1";
$count = mysql_result(mysql_query($sql),0,"count");
echo $count;

[Anon]

Thank you very much! Thats cool

The only problem i have now is that there are numbers like 2,5 or 4,3

is there a solution to count them also together?

greeetz mike

[Anon]

problem fixed! thanx