I am working on a project trying to develop a scoreboard that does the following in PHP / Mysql.
4 Columns across the top
Name | Rank | Score 1 | Score 2 | Total Score
On the back end you enter in score 1 and score 2 for the associated name, then I need a system that:
Ranks all of the entries in Score 1 and Score 2, If 2 people Tie it would output T (Then the Place) but the catch is if 2 people Tie for 1st then the next rank would be for 3rd not for 2nd
Total Score column is the sum of the Scores from Score 1 and Score 2 and then the list is sorted by this column
The rank column is the place they are in based on the total score and again it would have to say T (Then the Place if 2 people are tied for 1st and the next person down would be in 3rd)
Can anyone help me wrap my head around this it would be greatly appreciated.