<center><h1> Top 30 Players<br /> </h1>
<?php
$host = '109.169.62.251'
$user = 'sa'
$pass = '123456'

$myDB = "rxjhgame";
$link = mssql_connect($host, $user, $pw)
  or die("Couldn't connect to SQL Server on HeroGaming");
    if (!$link)
    {
    die('Could not connect: ' . mysql_error());
    }
mssql_select_db($myDB, $link);

$query = "SELECT TOP 30
FLD_LEVEL AS FLD_LEVEL,
FLD_NAME AS FLD_NAME,
FLD_JOB AS FLD_JOB FROM tbl_xwwl_char where J9 = 0
ORDER BY FLD_LEVEL DESC
              ";
$result = @mssql_query($query);


echo "<table border='0'>";
echo "<tr><th width=1>Level </th> <th width=40%>Character</th> <th width=20%>Job</th> </tr>";

$row = mssql_fetch_array($result)  or die(mysql_error());
	echo "<tr><td bgcolor=''>";
	echo $row['FLD_LEVEL'];
	echo "</td><td bgcolor=''>";
	echo $row['FLD_NAME'];
    echo "</td><td bgcolor=''>";
	include ('inc/class.php');
	echo "</td></tr>";

				echo "</table>";

?>

</center>