Re: pulling numbers from a column and getting a total
| From: | Dave W | Date: | Wed, 26 Jul 2006 15:12:29 +0000 |
| Subject: | Re: pulling numbers from a column and getting a total | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-42260@lists.php.net to get a copy of this message | ||
Thanks Natalie and Miles! The loop thing worked. What I had tried before was
put the echo inside the loop and it wasn't working, but now it does, w00t!
Thanks!
On 7/26/06, Miles Thompson <miles@allnovascotia.com> wrote:
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.-- Dave W$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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php