Hello all, i have maked a Guild Ranking Script, but when i will see this in Browser, he show me not all and incomplete. I am not a scripter, and need help for my script pls
PHP Code:
<center>
<h2>Top50 Guild Ranking</h2>
<?php
$server = "xxx.xxx.xxx.xxx";
$user = "sa";
$pass = "xxxxxxxxxxxxxxxxx";
$count=1;
$limit=50;
$conn = mssql_connect($server, $user, $pass)
or die("Couldn't connect to SQL Server on $server");
$query = "SELECT top $limit* FROM Telecaster.dbo.Guild order by 1 desc";
$result = mssql_query($query);
echo "<html><head>
<title>Guild Rankings</title></head>
<body><center>
<table><tr>
<td>Name</td>
<td>icon</td>
<td>Members</td>
<td>Dungeon</td>
<td>Leader</td></tr>";
while($row = mssql_fetch_array($result))
{
echo "<tr>
<td>$count</td>
<td>". $row['name'] ."</td>
<td>". $row['icon'] ."</td>
<td>". $row['xxxx'] . "</td>
<td>". $row['dungeon_id'] . "</td>
<td>". $row['xxxx'] . "</td>
</tr>";
$count++;
}
echo "</table>";
echo "</html>";
mssql_close($conn);
?>
</center>
can anyone help me that can i see all and complete? pls
What must i do for complete my script?