TOTAL CHARACTER:
Code:
<p class="style53">Total Character:<strong>
<?php
$query = mssql_query("SELECT * FROM Character");
$num_rows = mssql_num_rows($query);
echo "$num_rows"; ?>
Code:
<div align="center"><?php include "Config.php";
?>
<link rel="stylesheet" type="text/css" href="style.css">
<?php
$query = mssql_query("SELECT TOP 9999 * FROM Character order by XP desc");
$result= mssql_fetch_row($query);
?>
<style type="text/css">
<!--
.style28 {font-size: 10px}
.style29 {color: #FFFFFF; font-weight: bold; font-size: 10px; }
-->
</style>
<table width="442" border="1">
<tr >
<th colspan="8" scope="row"><span class="style28">Top Player List </span></th>
</tr>
<tr>
<th width="19" scope="row"><span class="style28"><strong>Bil</strong></span></th>
<td width="36"><span class="style28"><strong>Name</strong></span></td>
<td width="32"><span class="style28"><strong>Level</strong></span></td>
<td width="63"><span class="style28"><strong>ClanName</strong></span></td>
<td width="24"><span class="style28"><strong>Exp</strong></span></td>
<?php
for($i='';$i < mssql_num_rows($query);++$i)
{
$row = mssql_fetch_row($query);
$rank = $i+1;
?> <tr>
<th scope="row"><span class="style28"><strong><?php echo "$rank";?></strong></span></th>
<td><span class="style28"><strong><?php echo "$row[1]" ;?></strong></span></td>
<td><span class="style28"><strong><?php echo "$row[3]";?></strong></span></td>
<td><span class="style29"><?php echo "$row[8]";?></span></td>
<td><span class="style29"><?php echo "$row[9]";?></span></td>
</tr>
<?php }?>
</table></div>