> -----Original Message-----
> From: Ryan A [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 17, 2003 3:21 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> 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:[EMAIL PROTECTED]
> > Sent: Wednesday, September 17, 2003 3:08 PM
> > To: [EMAIL PROTECTED]
> > 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
> >
> >
> >
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
