[SOLVED] echo the sum of a field in a table

[lmhart]

I have a table that I can query the sum from with mysql and it gives a number but I can not get it to output to a php page. I get a resource id#3

 

<?php
include 'dbc.php';
$result = mysql_query("SELECT sum(record_amount) as total_expense from record");
echo $result
?>

[Daniel0]

Use mysql_fetch_row.

[mikesta707]

you have to use one of PHP's mysql_fetch_xxxx to get the results from your query

include 'dbc.php';
$result = mysql_query("SELECT sum(record_amount) as total_expense from record");
$row = mysql_fetch_assoc($result);
echo $ow['total_expense'];

 

Edit: beat me to it