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