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

cURL Upload Help
OK, I am creating a bridge from a local program to my website and I am trying to find the best way t

Ten Operator Syntax
Hi Guys,

I can't figure out why i am getting a parse error with this basic ten op code:

SQL query not working well
Hi,
I made a small table with 5 rows and want to make them an sql consult using rownum

foreach result into a single variable
Hi,

I have this code...

Code: [Select]foreach ($_POST['Interests'] as $interest =&

can i optmize image to 50% quality before uploading 2 server
Hi there

i have jus written a php program to upload and display images but when i try to uplo

NOOB needs help with upload file
The intent of this form is to create a folder for a client and upload an image into another folder '

Inserting the current date/time while submitting the forum
What do I need to add below to update the current date/time? I have a field in the database called d

INSERT for date range
Hi all

I have the following table

Code: [Select] `date` date
`day` int(2)
`

Losing 'page' data
I have this code that allows me to update my database. But after updating, I lose the $_GET['page']

Help with syntax
Hi all!

The $bridge variable is not getting passed while it is contained in the line below: