|
Subject:
|
summing column values
|
|
Posted By:
|
hydriswall
|
Post Date:
|
11/18/2006 2:32:42 PM
|
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
|
|
Reply By:
|
surendran
|
Reply Date:
|
12/8/2006 3:54:48 AM
|
$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
|
