Average data

[#1]

Hi there,

I need to create a table with the "best Racers"

i have the next details:

user name, full name, event raced in, type of event,  place, race course, gender and some other things.

i would like to make a table with the "best racers" and with the "worst racers"

for that - i would like to do an average on the PLACE the member got to on each competition and than show the top 5, for each competition and in GENERALL  in all competitions. as well as the worst competitors.

Thanks.

[#2]

Hi,

You can use the rank() function.

Succes!