Re: [PHP-DB] pulling numbers from a column and getting a total

2006-07-26 Thread Dave W 

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 <[EMAIL PROTECTED]> 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.
 $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





--
Dave W

Re: [PHP-DB] pulling numbers from a column and getting a total

2006-07-26 Thread Miles Thompson 

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

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] pulling numbers from a column and getting a total

2006-07-26 Thread Natalie Leotta 

I just reread your question and realized that you said you're already
displaying each number, so instead you might be better off with a variable
that you initialize to 0 and then in each iteration of your for loop add on
that value.

Natalie

On 7/26/06, Natalie Leotta <[EMAIL PROTECTED]> wrote:


http://www.techonthenet.com/sql/sum.php

That should help, Dave!

Natalie


On 7/26/06, Dave W <[EMAIL PROTECTED]> 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
>
>


--
Natalie Leotta
Independent Consultant
Arbonne International
607-785-2151
http://www.arbonne.com/





--
Natalie Leotta
Independent Consultant
Arbonne International
607-785-2151
http://www.arbonne.com/

Re: [PHP-DB] pulling numbers from a column and getting a total

2006-07-26 Thread Natalie Leotta 

http://www.techonthenet.com/sql/sum.php

That should help, Dave!

Natalie

On 7/26/06, Dave W <[EMAIL PROTECTED]> 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





--
Natalie Leotta
Independent Consultant
Arbonne International
607-785-2151
http://www.arbonne.com/

[PHP-DB] pulling numbers from a column and getting a total

2006-07-26 Thread Dave W 

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