Undefined index: name in (no loop)

[eduardodsilvaq 0]

Não sei oq tem de errado.

 

O erro:

Notice: Undefined index: name in C:\AppServ\www\includes\functions.php on line 105

A linha do erro:

    <td width="106"><div class="fonte">'. $row["name"] .'</div></td>

O codigo:

function mini_ranking (){
  $PDO = db_connect_gamedata();
  $sql = "SELECT name baselevel FROM u_hero WHERE class <> '80' ORDER BY baselevel Desc Limit 6";
  $result = $PDO->query($sql);
  $guild = $result->fetchAll(PDO::FETCH_ASSOC);
  $i = 1;
  echo '<table width="153" height="0" border="0">';
  foreach($guild as $row) {
  echo '<tr>
    <td width="0" height="0" align="center"><div class="fonte">'.  $i++ . '</div></td>
    <td width="106"><div class="fonte">'. $row["name"] .'</div></td>
    <td width="20"><div class="fonte">'. $row["baselevel"] .'</div></td>
    <tr>';
  }
  echo '</table>';
}

 

[eduardodsilvaq 0]

$sql = "SELECT name, baselevel FROM u_hero WHERE class <> '80' ORDER BY baselevel Desc Limit 6";

Faltava uma virgula ;-; 

Que feels bad mano