PHP:
$position = 1;
foreach($SQL->query('SELECT players.name, players.level, players.id, players_online.player_id FROM players,players_online ORDER BY players.level DESC LIMIT 8') as $i => $data)
{
echo $position .
' <a style="font-weight:bold;text-decoration:none;" href="?subtopic=characters&name='.
urlencode($data['name']).
'">'.
($data['players_online.player_id'] == $data['players.id'] ? "<font color=\"green\">". htmlspecialchars($data['name'])."</font>" : "<font color=\"red\">".htmlspecialchars($data['name'])."</font>").
'</a> ( ' .
$data['level'] .
' )<br>';
$position = $position+1;
}
That line don't work well
$data['players_online.player_id'] == $data['players.id'] ? "<font color=\"green\">". htmlspecialchars($data['name'])."</font>" : "<font color=\"red\">".htmlspecialchars($data['name'])."</font>").
All the time characters are "online" i mean GREEN
What is wrong?