Testing New Contest Specific Results Page

[acorn]

I've been working on an additional page that will be put up on the gripsport.org site once testing is complete. This one is for listing results for a specific contest and a single event or all events held at that contest. Can some of you guys test it for me and give feedback?

Here is an example link for this years Nationals:

http://www.az-grip.com/lists-contest.php?list=1&gender=1&event=all&contest=165&measurement=1

Thanks,

Aaron

[Tank Andrade]

I know less about computers than anyone under 70, but seems good to me Aaron. Thanks for all your hard work

[EricMilfeld]

There seems to be a glitch, if I'm interpreting it right. For example, someone who bested another's performance on a lift within the same weight class is ranked beneath the lesser lift.

[acorn]

There seems to be a glitch, if I'm interpreting it right. For example, someone who bested another's performance on a lift within the same weight class is ranked beneath the lesser lift.

Do you have an example?

For the All Events it is Athlete Name alphabetical listing. For individual event the sort should be ranked by result.

[EricMilfeld]

There seems to be a glitch, if I'm interpreting it right. For example, someone who bested another's performance on a lift within the same weight class is ranked beneath the lesser lift.

Do you have an example?

For the All Events it is Athlete Name alphabetical listing. For individual event the sort should be ranked by result.

Ah, you must be working on it as we speak. It's changing. But for a quick example, the 83k class isn't even listed in the weight class rankings for two hands pinch.

[acorn]

There seems to be a glitch, if I'm interpreting it right. For example, someone who bested another's performance on a lift within the same weight class is ranked beneath the lesser lift.

Do you have an example?

For the All Events it is Athlete Name alphabetical listing. For individual event the sort should be ranked by result.

Ah, you must be working on it as we speak. It's changing. But for a quick example, the 83k class isn't even listed in the weight class rankings for two hands pinch.

Which contest? I see 83Kg class lifts in both top 50 and weight class views?

Nevermind, I see it now. Looks like some more sql tuning to do. Only seeing it in the individual event results for that.

[acorn]

So I went through the database raw data after messing with the query a bit and not getting any better results on that example. I found that not all of the results are entered for all the athletes for that comp. A few are missing. In the case of the 2HP it looks like there are only 11 results of the 20 or so athletes entered. The other events have similar missing results with varying athletes. The person who entered the results should go through and double check what is actually in there and what needs to be added.

- Aaron