I am making a programme where at the end a total list is coming from out of a database order by the total scores, the highest first etc...
Every row gets a rang number in front of this line, but now I would like that if two or more rows have the same total score, the rang number isn't visible in front of the second row with that same total score and that the next country with a lower score get the right rang number.
1. Norway 120 points
2. Zweden 100 points
Danmark 100 points
4. Finland 80 points
Till now I have the following part of the script, but hopefully someone can tell me what I have to do to get this done. The total scores are based on $row and are taken out of a database.
The script is:
$query = "SELECT * FROM result order by Total desc";
$result = @mysql_query ($query); // Run the query.