RE: [PHP] Feeling a bit brain dead, please help in maths: averages
| From: | Craig Lonsbury | Date: | Wed, 17 Sep 2003 21:41:31 +0000 |
| Subject: | RE: [PHP] Feeling a bit brain dead, please help in maths: averages | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-162935@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Ryan A [mailto:ryan@coinpass.com]
> Sent: Wednesday, September 17, 2003 3:21 PM
> To: craig@topdraw.com; php-general@lists.php.net
> Subject: Re: [PHP] Feeling a bit brain dead, please help in maths:
> averages
>
>
> Hey,
> Thanks for replying.
>
> Actually I made that example simple, i actually need the average
> of 7 to 9
> fields....and i dont want to run 7 selects :-(
> I know its been done on elance....but how?
>
> Thanks,
> -Ryan
this should do the trick... but it's not tested ;)
#assuming you are using mysql and your query
#has successfully executed and your results
#are in $resultSet
$rowCount = 0;
$ageSum = 0;
$salarySum = 0; #use as many sums as needed
while ($row = mysql_fetch_object($resultSet)) {
$ageSum += $row->age;
$salarySum += $row->sal;
$rowCount++;
}
$salaryAvg = $ageSum / $rowCount;
>
>
> > off the top of my head:
> >
> > SELECT AVG(age), SUM(salTotal)
> > FROM blah
> > WHERE section = 3
> >
> > i'm not sure if you can use the 2 functions in the same query,
> > you might have to break it into 2 queries.
> >
> > Craig
> >
> > -----Original Message-----
> > From: Ryan A [mailto:ryan@coinpass.com]
> > Sent: Wednesday, September 17, 2003 3:08 PM
> > To: php-general@lists.php.net
> > Subject: [PHP] Feeling a bit brain dead, please help in maths: averages
> >
> >
> > Hey,
> > Been working a bit too much i guess so am feeling braindead...
> >
> > I have a couple of records in the database, i am doing a: "select
> > age,salTotal from blah where section=3"
> > this is getting me a list of records, how do i calculate the average age
> and
> > salary total (salTotal) to display in my php page?
> >
> > Cheers,
> > -Ryan A
> >
> >
> >
> >
> >
> >
> >
> > We will slaughter you all! - The Iraqi (Dis)information ministers site
> > http://MrSahaf.com
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> >
>
>