TOP 5 players script TFS 1.0+Gesior Acc

[povedijah]

Hello to everyone!
I'm trying to add to my web , the script of 5 highest levels, I have searched i have found some, but do nothing, i did not give errors, here I leave some examples:

    <?PHP
                            $position = 1;
                            foreach($SQL->query('SELECT `name`,`level`, `online` FROM players ORDER BY `level` DESC LIMIT 7') as $i => $data)
                            {
                                echo  $position . '  <a style="font-weight:bold;text-decoration:none;" href="?subtopic=characters&name='.urlencode($data['name']).'">'.($data['online']>0 ? "<font color=\"green\">".htmlspecialchars($data['name'])."</font>" : "<font color=\"red\">".htmlspecialchars($data['name'])."</font>").'</a> ( ' . $data[level] . ' )<br>';
                            $position = $position+1;
                            }
                        ?>

Maybe anyone have the correct one.

Thank you!

 

[EvulMastah]

$top = $SQL->query("SELECT `name`, `level`, `online` FROM `players` ORDER BY `level` DESC LIMIT 5")->fetchAll();
if($top)
    foreach($top as $player)
        echo 'hi';

Maybe something like this

 

[povedijah]

Thanks for reply. but i have a error in layout when i put the code.

bump