Simple Math Calculation

[Rich_Coy]

Ok, I am very new to PHP. I have written simple applications in ASP and Cold Fusion though so I do have some familiarity with SQL. Here is my question...

I simply want to add the numbers in a recordset and then divide by the total number of records that there are in the recordset.

For example to calculate the average grade on a test.

I spent 2 hours going through PHP and SQL books at the bookstore and could not find the answer.

If someone could point me to a website, or a book, that explains how to do calculations on numbers in a database I would greatly appreciate it!

Thanks!

Rich Coy

[WinterDragon]

I personally like the book: "PHP Bible" by Tim Cnverse, and Joyce park.

Its good. 🙂

[matto]

select avg(grade) from test where grade is not null and id_course=123

something like that?

[zudo]

you could put a query which selects a certain feild like the student current average and the put that in a variable and change that and then replace

[zudo]

If you are using a mysql database... send it to my e-mail at [e-mail] and iwill try to make code for it.