Top 10 '.$r_rgame['name'].' Players N° Player Name Rank Matches '; $ranking = 0; $sql_rplayer = "SELECT pi.id AS pid, pi.name, pi.country, r.rank, r.prevrank, r.matches FROM uts_rank AS r, uts_pinfo AS pi WHERE r.pid = pi.id AND r.gid = '$r_rgame[gid]' AND pi.banned <> 'Y' ORDER BY r.rank DESC LIMIT 0,10"; $q_rplayer = mysqli_query($GLOBALS["___mysqli_link"], $sql_rplayer) or die(mysqli_error($GLOBALS["___mysqli_link"])); if (mysqli_num_rows($q_rplayer) == 0) { echo ' No players entered the rankings yet.  
'; } else { while ($r_rplayer = mysqli_fetch_array($q_rplayer)) { $ranking++; $myurl = urlencode($r_rplayer[name]); echo' '.$ranking.' '.FlagImage($r_rplayer[country]).' '.htmlspecialchars($r_rplayer[name], ENT_QUOTES) .' '. RankMovement($r_rplayer['rank'] - $r_rplayer['prevrank']).' '.get_dp($r_rplayer[rank]).' '.$r_rplayer[matches].' '; } echo' Click here to see all the rankings
'; } } ?>