sum() problem

[sugradh]

Hi
I am trying a very simple thing, but cannot get it to work. I have the feeling this is quite a stupid question, but I cannot find out what I'm doing wrong...please help??

$conn=mysql_connect("$host_name","$db_user","$db_pass");
mysql_select_db("$db_name",$conn);

$totaal = mysql_query("SELECT sum(bedrag) FROM finance");

echo ("$totaal");

The result I get:

Resource id #5

[LordShryku]

You need to fetch them. And you should alias the sum

$totaal = mysql_query("SELECT sum(bedrag) AS total FROM finance");
$sum    = mysql_fetch_array($totaal);
echo $sum['total'];

[sugradh]

Weehaah!
I knew it would be that simple...Thank you!

Sugradh