Comment faire pour afficher les 3 plus grands résultats de `distance_traveled`
public function getMostDistancer2() {
$res = mysql_query('SELECT `uuid` name, SUM(`distance_traveled`) count
FROM players
WHERE distance_traveled != -1
GROUP BY `uuid`
ORDER BY count DESC
LIMIT 3');
while($row = mysql_fetch_assoc($res)) { $rows[] = $row; }
return $rows;
}
Dans ce contexte :
<?php
$ar = $serverObj->getMostDistancer();
$player = $serverObj->getPlayer($ar['name']);
if ($player) {
echo(STRING_ALL_DISTANCER);
?>
: </h2>
<a class="fort" href="?view=player&uuid=<?php echo($player->getUUID()); ?>"><?php echo($player->getName()); ?></a>
<?php
echo $rows[0];
?>
<?php } else echo(STRING_ALL_NONE); ?>
Erreurs actuelles :
Un grand merci à celui qui trouvera...NOTICE: UNDEFINED INDEX: NAME
Notice: Undefined variable: rows