[Help]Character Top and Total Character

Joined
Nov 17, 2006
Messages
511
Reaction score
0
Location
Estonia
kekku500 - [Help]Character Top and Total Character - RaGEZONE Forums

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"; ?>
TOP CHARACTER:
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>
 
Back