RE: [PHP] Feeling a bit brain dead, please help in maths: averages

2003-09-17 Thread Craig Lonsbury
> -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 repl

Re: [PHP] Feeling a bit brain dead, please help in maths: averages

2003-09-17 Thread Curt Zirzow
* Thus wrote Craig Lonsbury ([EMAIL PROTECTED]): > 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. Yes you can. And if you have other fields

Re: [PHP] Feeling a bit brain dead, please help in maths: averages

2003-09-17 Thread Ryan A
: [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

RE: [PHP] Feeling a bit brain dead, please help in maths: averages

2003-09-17 Thread Craig Lonsbury
er 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"

[PHP] Feeling a bit brain dead, please help in maths: averages

2003-09-17 Thread Ryan A
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 p