Gilden Ranking!

<?php
    include "./conf.php";
            $link = @mssql_connect($mssqlcon, $mssqluser, $mssqlpass) or die ("Server is down!"); 
    //No dual connection is needed because the original connection was never closed!!!!, Which is bad for memory and security.
            $db = @mssql_select_db('ACCOUNT_DBF') or die ("Accout table is missing!");
    class job {
            function jname($job) {


        if ($job == 0) $jname =  'N/A';
            else if ($job == 1) $jname = '<img src="img/Icon_CloakSLogo01.jpg">';
            else if ($job == 2) $jname = '<img src="img/Icon_CloakSLogo02.jpg">';
            else if ($job == 3) $jname = '<img src="img/Icon_CloakSLogo03.jpg">';
            else if ($job == 4) $jname = '<img src="img/Icon_CloakSLogo04.jpg">';
            else if ($job == 5) $jname = '<img src="img/Icon_CloakSLogo05.jpg">';
            else if ($job == 6) $jname = '<img src="img/Icon_CloakSLogo06.jpg">';
            else if ($job == 7) $jname = '<img src="img/Icon_CloakSLogo07.jpg">';
            else if ($job == 8) $jname = '<img src="img/Icon_CloakSLogo08.jpg">';
            else if ($job == 9) $jname = '<img src="img/Icon_CloakSLogo09.jpg">';
            else if ($job == 10) $jname = '<img src="img/Icon_CloakSLogo10.jpg">';
            else if ($job == 11) $jname = '<img src="img/Icon_CloakSLogo11.jpg">';
            else if ($job == 12) $jname = '<img src="img/Icon_CloakSLogo12.jpg">';
            else if ($job == 13) $jname = '<img src="img/Icon_CloakSLogo13.jpg">';
            else if ($job == 14) $jname = '<img src="img/Icon_CloakSLogo14.jpg">';
            else if ($job == 15) $jname = '<img src="img/Icon_CloakSLogo15.jpg">';
            else if ($job == 16) $jname = '<img src="img/Icon_CloakSLogo16.jpg">';
            else if ($job == 17) $jname = '<img src="img/Icon_CloakSLogo17.jpg">';
            else if ($job == 18) $jname = '<img src="img/Icon_CloakSLogo18.jpg">';
            else if ($job == 19) $jname = '<img src="img/Icon_CloakSLogo19.jpg">';
            else if ($job == 20) $jname = '<img src="img/Icon_CloakSLogo20.jpg">';
            else if ($job == 21) $jname = '<img src="img/Icon_CloakSLogo21.jpg">';
            else if ($job == 22) $jname = '<img src="img/Icon_CloakSLogo22.jpg">';
            else if ($job == 23) $jname = '<img src="img/Icon_CloakSLogo23.jpg">';
            else if ($job == 24) $jname = '<img src="img/Icon_CloakSLogo24.jpg">';
            else if ($job == 25) $jname = '<img src="img/Icon_CloakSLogo25.jpg">';
            else if ($job == 26) $jname = '<img src="img/Icon_CloakSLogo26.jpg">';
            else if ($job == 27) $jname = '<img src="img/Icon_CloakSLogo27.jpg">';
            else $jname = 'An applicable job name could not be found in our records.';
            return $jname; 


       }
    }
    $job = new job;
?>


<table width="100%" border="0" cellpadding="1" cellspacing="1">
        <tr>
          <td height="23" colspan="6" background="sub.jpg"><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
              <tr>
                <td><center>
<?php
           $query = mssql_query('SELECT * FROM [ACCOUNT_TBL]');
            echo 'Total Accounts: ' . mssql_num_rows($query);
?>
</center></td>
                <td><center>
<?php
            $db = @mssql_select_db('CHARACTER_01_DBF') or die ("Accout table is missing!");
                    $query = mssql_query('SELECT * FROM [CHARACTER_TBL]');
                    echo 'Total Characters: ' . mssql_num_rows($query);
?>
</center></td>
              </tr>
            </table>
            <div align="center" class="style66">TOP 20 </div></td>
          </tr>
        <tr>
        <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9">
              <div align="left" class="style72">No.</div>          </td>
          <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9">
              <div align="left" class="style72">Name</div>          </td>
          <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Gilden Level</div></td>
          <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Logo</div></td>
          <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Verloren</div></td>
          <td height="23" background="gradient_thead.gif" bgcolor="#00CC00" class="style9"><div align="center" class="style72">Gewonnen</div></td>
        </tr>
 
<?php
                $db = mssql_select_db("CHARACTER_01_DBF");
        $resTop = mssql_query("SELECT TOP 50 P.m_szGuild, P.m_nLevel, P.m_nLose, P.m_nWin, P.m_dwLogo FROM CHARACTER_01_DBF.dbo.GUILD_TBL P ORDER BY P.m_nLevel DESC");
        $ctr = 1;
        while ($row3 = mssql_fetch_array($resTop)) {
            $chNm = $row3["m_szGuild"];
            $chLv = $row3["m_nLevel"];
            $chLogo = $row3["m_dwLogo"];
            $chCls = $row3["m_nLose"];
            $chmap = $row3["m_nWin"];
?>
        <tr>
        <td bgcolor="#FFFFFF" class="submit"><span class="style68">
            <?php echo $ctr++; ?>
          </span></td>
          <td bgcolor="#FFFFFF" class="submit"><span class="style68">
            <?php echo $chNm; ?>
          </span></td>
          <td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
              <?php echo $chLv; ?>
          </span></div></td>
          <td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
              <?php echo $job->jname($chLogo); ?>
          </span></div></td>
          <td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
              <?php echo $chCls; ?>
          </span></div></td>
          <td bgcolor="#FFFFFF" class="submit"><div align="center" class="style72"><span class="style1">
              <?php echo $chmap; ?>
          </span></div></td>
        </tr>
<?php
}
mssql_close($link);
?>
        <tr>
          <td colspan="6" background="bg_tile.gif" bgcolor="#666666">&nbsp;</td>
          </tr>
        
      </table>