Index.php: Código HTML:
<h3>Top 10 Personajes</h3>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tbody>
<?php include("modules/rankings/top_10_personajes.php"); ?>
</tbody>
</table> top_10_personajes.php Código HTML:
<?
$query = "SELECT pj,d0 from cuentas order by d0 desc LIMIT 10";
$result = mysql_query($query);
echo '<tr>
<td><a href="" class="mainlevel">#</a></td>
<td><a href="" class="mainlevel">Nombre</a></td>
<td><a href="" class="mainlevel">Level</a></td>
</tr>';
for($i=0;$i < mysql_num_rows($result);++$i)
{
$row = mysql_fetch_row($result);
$rank = $i+1;
echo "<tr>
<td><a href='main.php?op=character&character=$row[0]' class='mainlevel'>$rank.</a></td>
<td><a href='main.php?op=character&character=$row[0]' class='mainlevel'>$row[0]</a></td>
<td><a href='main.php?op=character&character=$row[0]' class='mainlevel'>$row[1]</a></td>
</tr>";
}
?>