$req = mysql_query("SELECT *, (SELECT COUNT(*) FROM danseurs_$Saison WHERE Catégorie='$Catégorie' AND valid<>'x' AND Total_points >= ge.Total_points) as place FROM danseurs_$Saison ge WHERE Catégorie='$Catégorie' AND valid<>'x' ORDER BY Total_points DESC") or die ('Erreur SQL 1!'.$req.'<br>'.mysql_error());

select joueur_id, 1+count(b.points) as position
from joueurs a
    left join joueurs b on a.points < b.points
group by a.joueur_id
order by position desc, joueur_id asc

mysql> select * from danseurs
+-----------+------+--------+
| idDanseur | nom  | points |
+-----------+------+--------+
|         1 | Toto |     10 |
|         2 | Tata |    100 |
|         3 | Titi |     50 |
|         4 | Tutu |     20 |
|         5 | Tete |     50 |
+-----------+------+--------+

CREATE PROCEDURE Classement()
    NOT DETERMINISTIC
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN

        DECLARE var_id INT;
        DECLARE var_nom VARCHAR(100);
        DECLARE var_points INT;
        
        DECLARE var_position INT DEFAULT 0;
        DECLARE var_numero INT DEFAULT 0;

        DECLARE var_pointprecedent INT DEFAULT NULL;
        

        DECLARE done INT DEFAULT 0;
        DECLARE curseur1 CURSOR FOR SELECT * FROM danseurs ORDER BY points DESC;
        DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;

        DROP TEMPORARY TABLE IF EXISTS TempDanseurs;
        CREATE TEMPORARY TABLE TempDanseurs (
        idDanseur INT NOT NULL PRIMARY KEY,
        nom VARCHAR(100) NOT NULL,
        points INT NOT NULL,
        position INT NOT NULL
        ) ENGINE=MEMORY;

        OPEN curseur1; # ouverture du curseur1

        REPEAT
                FETCH curseur1 INTO var_id, var_nom, var_points;
                IF done = 0 THEN

                        SET var_numero := var_numero + 1;
                
                        IF( var_pointprecedent IS NULL OR var_points < var_pointprecedent) THEN
                            SET var_position := var_numero;
                        END IF;
            
                        SET var_pointprecedent := var_points;
            
                        INSERT INTO TempDanseurs(idDanseur, nom, points, position) VALUES (var_id, var_nom, var_points, var_position);

                END IF;

        UNTIL done
        END REPEAT;

        CLOSE curseur1; # fermeture du curseur1

        SELECT * FROM TempDanseurs ORDER BY position;
        
END|

mysql> CALL Classement();
+-----------+------+--------+----------+
| idDanseur | nom  | points | position |
+-----------+------+--------+----------+
|         2 | Tata |    100 |        1 |
|         5 | Tete |     50 |        2 |
|         3 | Titi |     50 |        2 |
|         4 | Tutu |     20 |        4 |
|         1 | Toto |     10 |        5 |
+-----------+------+--------+----------+

select Dossards, 1+count(b.Total_points) as place
from danseur_$Saison a
    left join danseur_$Saison b on a.Total_points < b.Total_points
group by a.Dossards
order by place desc, Dossards asc

mysql> SET _AT_num := 0, _AT_rank := 0, _AT_prev := NULL;
mysql> SELECT _AT_num := _AT_num + 1 AS row,
_AT_rank := if(@prev != php, _AT_num, _AT_rank) AS rank,
country, _AT_prev := php AS php
FROM statsPHP ORDER BY php;
+------+------+---------------+-----+
| row | rank | country | php |
+------+------+---------------+-----+
| 1 | 1| Polynésie Fr.    | 67 |
| 2 | 2| Turk & Caicos   | 55 |
| 3| 3| France              | 41 |
| 4| 4| USA                 | 31 |
| 5| 4| Canada            | 31 |
| 6| 6| Groënland        | 17 |
| 7| 6| Israel               | 17 |
+------+------+---------------+-----+

select Dossards, 1+count(b.Total_points) as place
from danseur_$Saison a
    left join danseur_$Saison b on a.Total_points < b.Total_points
group by a.Dossards
order by place desc, Dossards asc

select a.Dossards, 1+count(b.Total_points) as place
from danseur_$Saison a
    left join danseur_$Saison b on a.Total_points < b.Total_points
group by a.Dossards
order by place desc, a.Dossards asc

select *, 1+count(b.Total_points) as place
from danseur_$Saison a
    left join danseur_$Saison b on a.Total_points < b.Total_points
group by a.Dossards
order by place asc

WHERE Catégorie  ='Cadet 3' AND valid  <>'x'