<?php
$hostname = "VPS350363";
$username = "AdminMU";
$password = "1602950024tomeks";
$dbName = "MuOnline";
// SQL Connection set CHECK
MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO RESPOND.");
mssql_select_db($dbName) or DIE("Table unavailable");
// Display the data by query
$query = "SELECT * FROM T_BLOOD_CASTLE";
$result = mssql_query( $query );
// Some Desing
echo '<table>';
echo '<tr><td bgcolor=#ffffff><center><font face=Arial size=2><b>Rank</td><td bgcolor=#ffffff><font face=Arial size=2><b>Character</b></font></td><td bgcolor=#ffffff><font face=Arial size=2><b>Stones</b></font></td>';
for($i=0;$i < 10;++$i){
$top = mssql_fetch_row($result);
echo '<tr><td bgcolor=#ffffff width=40><font face=Arial size=2>';
echo $i + 1;
echo '.</font></td><td bgcolor=#ffffff width=110><FONT SIZE=2 face=Arial font color=blue><b>';
echo $top[0];
echo '</b></font></td><td bgcolor=#ffffff width=30><font face=Arial size=2 font color=gray>';
echo $top[1];
echo'</font></td></tr>';}
echo '</tr></table>';
echo '</table>';
echo '</body>';
echo '</html>';
echo '';
//Make sure to close out the database connection
mssql_close();
?>
rena.php
Open with
Displaying rena.php.