how can i sum column values from mysql result within my php script. my query is
query = mysql_query(select sum(debit), sum(credit), sum(balance) from table where office = 'james');
please someone help
thank you

$query = mysql_query("select sum(debit) as t1, sum(credit) as t2, sum(balance) as t3 from table where office = 'james'");
while($row = mysql_fetch_array($query)){
$fulltotal=$row['t1']+$row['t2']+$row['t3'];
echo($fulltotal);
}

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com