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

Putting double spaces instead of single spaces
Im looking at trying to replace all single spacing between fields with double spacing

At pres

ME54/ME54N Conditional check for Release of PR
Hi Gurus,

My requirement is to put a check on the release of the PR with respect to the c

why preg_match_all does not return the number of matches
My regex looks like

X[^x{4e00}-x{9fa5}]*Y

(where X and Y are two Chinese characters)

article site help remaining text
Hi all hope you will be fine
I am creating a article site in this site i want to put some text on

first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see

Re-Order by ID Number
I have a cms set up for inputting an image, thumb, title, pdf, and eps. When input the database ass

Backflush
I am looking for a report in SAP that would give me a list of all parts that are populated with a ba

close site for maintenance
i get a tutorial, saying the following code can put our site offline, and only the developer can vie

Seperate team from score
I am writing a site that does a NFL Pick 'em type application and I have a feed that gives me the sc

script and html conflict in trying to create a header.
I have an error is occurring because of an html webpage with a "php require" at the top of