[SOLVED] Sum of Values in an Array

[Jen-a-Bean]

This is probably really simple... but it's been years since I've written anything, so bare with me!

 

I've got a MySQL database setup with a table that has multiple fields, where one is a numerical balance.  I want to fetch all of these balances, add them together, and print a total.

 

This is what I have so far:

 

		$acctTotal = mysql_query('SELECT bal FROM assets WHERE term = \'C\'');
	while($row = mysql_fetch_assoc($acctTotal)){
		echo $row[bal];
	}

[Jen-a-Bean]

Ask for help and I figure it out... go figure.

 

		$acctTotal = mysql_query('SELECT bal FROM assets WHERE term = \'C\'');
	while($row = mysql_fetch_assoc($acctTotal)){
		$subtotal += $row[bal];
	}
	echo $subtotal;

[DavidAM]

If all  you want is the total, and you are not going to do anything with the actual balances, let the database do the work:

 

SELECT SUM(bal) AS TotBal FROM assets WHERE term = 'C'