PHP|Débutant :: Forums

$RechercheJoueur="SELECT * FROM `sondage_choix` WHERE `vote`>0 ORDER BY `vote` DESC";
$resultat = mysql_query($RechercheJoueur);
     $lastScore = '';
    $displayPos = 1;
    $realPos = 1;
//je prends en compte les égalités de points
    while ($data = mysql_fetch_array($resultat))
    {
       $prenom[$realPos]= $data['intitule'];
      $currentScore = $data['nbr'];
     
      if ($currentScore != $lastScore)
        {
          $displayPos = $realPos;
        }
      $lastScore = $currentScore;
     
           
      //$prenom[$realPos]= $data['intitule'];
      $realPos++;
     
    }
   
      $query1="SELECT * FROM `recompenses` WHERE `PRENOM` LIKE '".$prenom[1]."'";
 
      $resultat1 = mysql_query($query1) or die(mysql_error());
      $data = mysql_fetch_array($resultat1);
      $prenom[1]= $data['PRENOM'];
      $Pts_avant[1] = $data['PTS'];
      $Pts_premier[1]=$Pts_avant[1]+30;
      $query = "UPDATE `ifb_mysql`.`recompenses` SET `PTS`='".$Pts_premier[1]."' WHERE `PRENOM` LIKE '".$prenom[1]."'";
      $result = mysql_query($query) or die(mysql_error());
     
     
     
      $query2="SELECT * FROM `ifb_mysql`.`recompenses` WHERE `PRENOM` LIKE '".$prenom[2]."'";
 
      $resultat2 = mysql_query($query2) or die(mysql_error());
      $data = mysql_fetch_array($resultat2);
      $prenom[2]= $data['PRENOM'];
      $Pts_avant[2] = $data['PTS'];
      $Pts_premier[2]=$Pts_avant[2]+20;
      $query = "UPDATE `ifb_mysql`.`recompenses` SET `PTS`='".$Pts_premier[2]."' WHERE `PRENOM` LIKE '".$prenom[2]."'";
      $result = mysql_query($query) or die(mysql_error());
   
      $query3="SELECT * FROM `ifb_mysql`.`recompenses` WHERE `PRENOM` LIKE '".$prenom[3]."'";
 
      $resultat3 = mysql_query($query3) or die(mysql_error());
      $data = mysql_fetch_array($resultat3);
      $prenom[3]= $data['PRENOM'];
      $Pts_avant[3] = $data['PTS'];
      $Pts_premier[3]=$Pts_avant[3]+10;
      $query = "UPDATE `ifb_mysql`.`recompenses` SET `PTS`='".$Pts_premier[3]."' WHERE `PRENOM` LIKE '".$prenom[3]."'";
      $result = mysql_query($query) or die(mysql_error());