Warning: mysql_fetch_row() sur requete qui fonctione

slt, j'ai un petit pb

Citation:

---

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/derniere/domains/derniere-bataille.net/public_html/game/classement.php on line 76

---

or ma requete quand je l'affiche

Code:

---

SELECT players.id, players.pseudo, players.team, players.xp_spatiale, players.xp_terre, COUNT(planetes.players) FROM players INNER JOIN planetes ON players.id = planetes.players WHERE active !=0 GROUP BY players.id, players.pseudo, players.team, players.xp_spatiale, players.xp_terre ORDER BY `COUNT( planetes . players )` DESC

---

et que l'execute sous phpmyadmin elle fonctionne :roll:

Code:

---

1 2 3 4 5

73. echo $sql; 74. $req = mysql_query($sql); 75. $i = 0; 76. while(list($players_id, $players_pseudo, $players_team, $players_xp_spatiale, $players_xp_terre, $players_planetes) = mysql_fetch_row($req)) {

---

Salut,

dans ton count : planete.players dans ton list() players_planete

Dans ce genre de requête j'aliasse la colonne count

Code:

---

SELECT players.id, players.pseudo, players.team, players.xp_spatiale, players.xp_terre, COUNT(planetes.players) as nb_planetes_players FROM players INNER JOIN planetes ON players.id = planetes.players WHERE active !=0 GROUP BY players.id, players.pseudo, players.team, players.xp_spatiale, players.xp_terre ORDER BY `COUNT( planetes . players )` DESC

---

Code:

---

76. while(list($players_id, $players_pseudo, $players_team, $players_xp_spatiale, $players_xp_terre, $nb_planetes_players) = mysql_fetch_row($req))

---

merci :wink: