Determiner le rang d'un élève

 $sql = "SELECT E.* , M.*
         FROM eleve E
         LEFT JOIN moyengeneral M ON M.ideleve = E.ideleve
         WHERE E.class = ? 
         AND E.iduser = ? 
         ORDER BY M.moyene DESC";
 $datas = array($class, $iduser);
 
  try {  
    $req = $bdd->prepare($sql);
    $req->execute($datas);
    $donnees = $req->fetchAll(); //on stocke le resultat de la requete dans un ARRAY
  } catch(Exception $e){
      die('Erreur : '.$e->getMessage());
  }   

 $sql = "SELECT E.* , M.*
         FROM eleve E
         LEFT JOIN moyengeneral M ON M.ideleve = E.ideleve
         WHERE E.class = ? 
         AND E.iduser = ? AND M.moyene >= ? 
         ORDER BY Rang DESC";
 $datas = array($class, $iduser, $moyen);