requête SQL:

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 )
LIMIT 0 , 30
MySQL a répondu:

#1111 - Invalid use of group function

$sql = "SELECT players.id, players.pseudo, players.team, players.xp_spatiale, players.xp_terre, players.grade, players.description, 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";
switch($_GET['req'])
{
	case "nom": $sql = $sql." ORDER BY players.pseudo"; break;
	case "xps": $sql = $sql." ORDER BY players.xp_spatiale DESC"; break;
	case "xpt": $sql = $sql." ORDER BY  players.xp_terre DESC"; break;
	case "nbp": $sql = $sql." ORDER BY nb_planetes_players DESC"; break;
	default : $sql = $sql." ORDER BY nb_planetes_players DESC";
}

$a = $a . $b;

$a .= $b;