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

webpage with (simple) login & mysql-db
Hi all,

What I was looking for before was a multi-user password manager, web-based! The offer

Spaghetti Code
So.

I've pretty much reached the point where I have so many isset s on one page that I can't

PHP and Javascript
Hello Everyone,

I have a page that needs a javascript code to be written between PHP code but

retrieving images from mysql database using php
So I've been trying to figure out how to store images in a mysql database, and as far as i can tell

Rounding a number queried from a database
I know that to display a rounded number you just do echo "round($number)";. But how would

Last character removed
I have created a string from an array. I have inserted commas from my form values. I am trying to re

Refining of search Criteria
Dear Friends

I need a help, I have a search page which of cars related, which has different s

help with multi-update
Now sure how to ask this really....
10g database if that matters.

I have a customer

ALV List Display to point to another report on Double Click
Hi,

I want my ALV List Display to point to another report on Double Click on its line ite

Are sessions secure at all?..
I haven't really gotten into yet, but I was just thinking of something weird..

Lets say you h