Re: pulling numbers from a column and getting a total
| From: | Miles Thompson | 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 WDave, 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