Gossamer Forum
Home : Products : DBMan : Discussions :

averaging each field

Quote Reply
averaging each field
Hello,

I have messed a bit with get_average - but no luck. Here is what I am after - any beginning guidance would be appreciated:

I have user posting several records - each field contains a small whole number (0 to 12) - their record can then be displayed as seen here: http://www.cspweb.net/cgi-bin/dbman/golf/db.cgi?db=default&uid=default&sb=58&so=descend&view_records=1&ID=*

What I am after is to display a user's AVERAGES for each field. So we would need to add up all the entries in each of a particular field and then divide by that number and display - doing this for each of the fields.

Again, any direction to start is appreciated.

Thanks,

Jim

Subject Author Views Date
Thread averaging each field jog 2530 Jul 18, 2001, 1:34 PM
Post Re: averaging each field
LoisC 2418 Jul 20, 2001, 10:29 AM