Ai também estou me matando :/

já tentei aqui e sempre da um erro.

Consegui:

coloca isso na sua pagina php

$autor = $SQL->query('SELECT `name` FROM `players` WHERE `id` = ' . $ban['banned_by'] .' LIMIT 1')->fetch();

e para apresentar só colocar isso:

    <td>   ' . $autor['name'] . ' </td><tr>';

Deu não.. e nem dá erro na página.

 

ela fica em branco e mais nada

Editado Novembro 3, 2014 10 anos por Lumus (veja o histórico de edições)

Ve essa:

é a que estou usando

 

<style type="text/css">

.tg  {border-collapse:collapse;border-spacing:0;}

.tg td{font-family:Arial, sans-serif;font-size:10px;padding:1px 50px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}

.tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}

</style>

 

 

<?PHP

 

///

 

$data = $SQL->query('SELECT `players_data`.`name`, `account_bans`.`account_id`, `account_bans`.`reason`, `account_bans`.`banned_at`, `account_bans`.`expires_at`, `account_bans`.`banned_by` FROM `account_bans` INNER JOIN (SELECT * FROM (SELECT `account_id`, `name` FROM `players` WHERE `players`.`account_id` IN (SELECT `account_id` FROM `account_bans`) ORDER BY `level` DESC) x GROUP BY `account_id`) players_data ON `account_bans`.`account_id` = `players_data`.`account_id`')->fetchAll();

echo '<p align="center"><br/>

 

 

 

';

echo ' <table class="tg">

<th class="tg-031e">Number.</th>

<th class="tg-031e">Player</th>

<th class="tg-031e">Reason</th>

<th class="tg-031e">Expires</th>

<th class="tg-031e">Autor</th>

<tr>

 

';

 

foreach($data as $i => $ban)

{

 

$autor = $SQL->query('SELECT `name` FROM `players` WHERE `id` = ' . $ban['banned_by'] .' LIMIT 1')->fetch();

 

 

 

 

    echo '<td>' .($i+1) . '.</td><td><font color=red><a href="?subtopic=characters&name=' . urlencode($ban['name']) . '"></font>' .htmlspecialchars($ban['name']). '</a></td>

   

    <td>' . htmlspecialchars($ban['reason']) . '<br /></td>

   <td>' . date("j/m/Y, G:i", $ban['expires_at']) . '<br /></td>

    <td>   ' . $autor['name'] . ' </td><tr>';

}

  echo '</table>';

 

  ?>