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

Php - mysql store data and use it later?
Hi, i' making a login page at the moment, however my username + password is stored many different pl

problem with sql querry in php script
Hello guys,

What I want to do is I want to read out a csv file and then but te conent ot the

System copy error in RUN ABAP REPORT PHASE
Hi,
I am performing system copy on my test server. I have previously taken export of JAVA + A

PHP FTP connect doesn't work with correct login
Hi!

i am working on this test code:
Quote<?php

$ftp_ser

Feed Maker
Hi all.
First of all I must say I am not a php developer so I am afraid I don't know much about i

need help modifying script
Hi guys,

I'm fairly new to php and am having a bit of trouble modifying a script.

This

Simple image grab script.
I was wondering if it was possible and if anyone knew how to make a simple php script that looks at

please hep to get values from a table row
can anyone tel me how I can select and get data from one row by pressing an Edit button in that row

having a small php error tha deals with the 'foreach'
Last night i was working on a script for a cart and it seemed to working good, until this morning. F

Batch Session SM35 stuck in status 'in Background
Hi Experts,

I am facing a problem with Batch Input session SM35.

The batch se