<?php
    $server= "127.0.0.1";
    $user = "your_user";
    $pass = "your_pass";
    $db = "your_db";
    $con = mysql_connect($server, $user, $pass) or die(mysql_error()); mysql_select_db($db, $con) or die(mysql_error());
    ?>
    <table width="100%" border="0">
        <tbody>
            <tr>
                <td>Player Name</td>
                <td>Class</td>
                <td>Clan</td>
                <td>Times Hero</td>
            </tr>
    <?php
    $sql = mysql_query("SELECT * FROM heroes as h,characters as c WHERE h.charId = c.charId ORDER BY h.count DESC") or die(mysql_error());
    while($c = mysql_fetch_array($sql)) {
          $h = mysql_query("SELECT * FROM characters WHERE charId = '".$c['charId']."'") or die(mysql_error());
          $n = mysql_fetch_array($h);
          $l = mysql_query("SELECT * FROM class_list WHERE id = '".$n['base_class']."'") or die(mysql_error());
          $g = mysql_fetch_array($l);
          $i = mysql_query("SELECT * FROM clan_data WHERE clan_id = '".$n['clanid']."'") or die(mysql_error());
          $j = mysql_fetch_array($i);
          $g['class_name'] = explode("_", $g['class_name']);
          $j['clan_name'] = empty($n['clanid']) ? 'No Clan' : $j['clan_name'];
          ?>
            <tr>
                <td><?php echo $n['char_name']; ?></td>
                <td><?php echo ucwords($g['class_name'][1]); ?></td>
                <td><?php echo $j['clan_name']; ?></td>
                <td><?php echo $c['count']; ?> </td>
            <? } ?>
            </tr>
        </tbody>
    </table>
    <?php mysql_close(); ?>