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 > 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
