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
