Sim as duas tem. Bom o código fico assim. <?
Include ('../../Configuration/Config.php');
$query = "SELECT crb.charId, crb.rec_have, c.char_name FROM character_reco_bonus as crb INNER JOIN characters as c WHERE crb.charId = c.charId AND c.charId = '".$a->charId."' ORDER BY crb.rec_have DESC LIMIT 10";
$result = mysql_query($query) or die('Erro:'.mysql_error());
while ($row = mysql_fetch_object($result)) {
$b = mysql_query("SELECT * FROM character_reco_bonus where ".$a->charId." = charId ORDER BY rec_have DESC LIMIT 10" );
$c = mysql_fetch_object($b);
?>
<table>
<tr>
<td><?php echo $a->charId; ?></td>
<td><?php echo $a->char_name; ?></td>
<td><?php echo $c->rec_have; ?></td>
</tr>
</table>
<?
$i++;
}
?>
Esta correto?
Ele não deu erro nem uma mas não carrego nem um dado na tela.
Hehehe porque ta tudo erado =P.
Tenta esse:
<?
Include ('../../Configuration/Config.php');
$query = "SELECT crb.charId, crb.rec_have, c.char_name FROM character_reco_bonus as crb INNER JOIN characters as c WHERE crb.charId = c.charId AND c.charId = '".$a->charId."' ORDER BY crb.rec_have DESC LIMIT 10";
$result = mysql_query($query) or die('Erro:'.mysql_error());
while ($row = mysql_fetch_array($result)) {
?>
<table>
<tr>
<td><?php echo $row['charId']; ?></td>
<td><?php echo $row['char_name']; ?></td>
<td><?php echo $row['rec_have']; ?></td>
</tr>
</table>
<?
}
?>
