Re: pulling numbers from a column and getting a total

From: Date: Wed, 26 Jul 2006 14:07:12 +0000
Subject: Re: pulling numbers from a column and getting a total
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-42259@lists.php.net to get a copy of this message
At 10:27 AM 7/26/2006, Dave W wrote:
Hi, I was just wondering on how I could get a whole column full of integers and added them up and display that total? I currently use a for loop to display the whole column in a table, but I wanted to add all those numbers up. Thanks. -- Dave W
Dave, You're v. close to an answer. Think about it a bit. Initialize a variable before your loop, setting it to zero.
        $tot = 0;
In the loop, add the amount to that variable,
        $tot += $num_to_add;
OR
        $tot = $tot + $num_to_add;
After the loop, echo $tot. HTH - Miles -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.10.4/399 - Release Date: 7/25/2006

« previous php.db (#42259) next »