I'm stuck on a site I'm building, I need to make a ranking page that shows results from contests and sorts them by points and gives them a ranking 1 to however may people competed. I have the basics done, I can get the info in the DB and display it on the page but as for the sql query I need to sort the results I'm stumped. It would end up like this:
Rank Rider Total Points Comp1 Comp2
1 John 1000 500 500
2 Fred 800 400 400
So it would add all the comp columns give a total and then rank based on the highest points
Here is an example of what I need to do.
Thank you for any help you can provide...I've googled my self to death looking for tuts on the subject.