Sum of Values in an Array

Posted on 16th Feb 2014 07:03 pm by admin

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];
}

Your Answer:

Login to answer

Other forums

passing an array of objects after submit
How do I do this? This is what I have tried and it is not working.

<form method="

multipart emiail forms
Hi All,

I am new to the boards and I've been working on a form (which is rather massive, imo

Passing an array of values From VB6.0 to Oracle PL/SQL Function
Basically we are using VB6.0.

When we try to pass an array from VB6.0 to an Oracle PL/SQL

Facebook status update API
Hello,

So, I'm trying to create my first Facebook application with PHP.

Basic ideas fo

Vertical Alligning - Not working in 1 cell?
<?php

echo "<table id="valign" width="60%" style=

$get problem
Hi Guys ...

can you please tell me what i am doing wrong here
Code: <?php

Extract specific information from a PHP Multidimensional Array
Howdy! I've racked my brain over this for 24 hours now. I think it's time I asked for help. I'm lear

how to load php class from another domain?
how to load php class from another domain?

User feedback after MySQL query has been executed
Hi all, I've just registered on PHPFreaks because I've got a question that I simply can't work out b

Automatic Webpage ??
I have a page www.mysite.com/test.php with a
<form>
<textarea name=&q