Re: Average Number For Math Functions
| From: | VolVE | Date: | Fri, 30 Aug 2002 03:31:03 +0000 |
| Subject: | Re: Average Number For Math Functions | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-114588@lists.php.net to get a copy of this message | ||
What database are you using?
MySQL has a SUM function which automatically selects the total of a column.
-VolVE
----- Original Message -----
From: "JohnP" <aerc@aerc.biz>
To: <php-general@lists.php.net>
Sent: Thursday, August 29, 2002 21:25
Subject: Re: [PHP] Average Number For Math Functions
> Ok so how do I sum up an entire column in my db?
> For example if one row is : 1 , the next is 2, and the next is 1 - I need
to
> have a total of 4 and the be able to divide by the num_rows
>
> The problem I ma having is the "inside" row addition
>
>
>
>
> "Martin Towell" <martin.towell@world.net> wrote in message
> {k$;̐I'
> :news:6416776FCC55D511BC4E0090274EFEF5034CFD12@exchange.world.net...
> > just sum them up and divide by the count - making sure to deal with a
> count
> > of zero
> >
> > -----Original Message-----
> > From: JohnP [mailto:aerc@aerc.biz]
> > Sent: Friday, August 30, 2002 10:56 AM
> > To: php-general@lists.php.net
> > Subject: [PHP] Average Number For Math Functions
> >
> >
> > Ok I looked at all the math functions for PHP but saw no way of
returning
> > the average of a set of numbers - I plan on using this for a rating
> system -
> > any help?
> >
> > --
> > John
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>