[Web]Script Ranking

[ThunterBR]

I Make the Script for Select Ranking TOP Levels
***********************************************



<?php

$host = "(local)"; // your sql instance
$user = "sa"; // username
$pw = ""; // password
$db = "Telecaster"; // db
$md5_key = "2011"; // your md5 key
$num = "15"; // num TOP
$connect = mssql_connect($host,$user,$pw)
or die("Can't connect to the datebase.");

mssql_select_db($db,$connect)
or die("Can't select the datebase");

?>
<center>
<h1>Ranking - Top <?php echo $num;?></h1><hr /><br />
<?php
//Created by Admin Thunder
echo '<div align="center"><table width="30%" border="1" bgcolor="#EEEEEE" style="text-align:center;">';
echo '<td width="5%" bgcolor="#FFFFFF"><b>Rank';
echo '<td width="25%" bgcolor="#FFFFFF"><b>Name';
echo '<td width="25%" bgcolor="#FFFFFF"><b>Level';
echo'</tr>';
$rank=1;

$getrank = mssql_query('SELECT TOP '.$num.' * FROM dbo.Character ORDER BY lv DESC');

while ($consulta = mssql_fetch_assoc($getrank)) {
$nameid = $consulta['name'];
$getleader = mssql_query('SELECT name FROM dbo.Character WHERE name = "'.$nameid.'" AND lv = "0"');

while ($leaderid = mssql_fetch_assoc($getleader)) {
$uid = $leaderid['lv'];
}
echo '<tr><td bgcolor="#FFF0F0">'.$rank.'</td>';
echo '<td bgcolor="#FFF0F0">'.$consulta['name'].'</td>';
echo '<td bgcolor="#FFF0F0">'.$consulta['lv'].'</td>';
$rank++;
}
//********
?>
</table>

[qaaah]

where i paste this
or how this work?

[Musta²]

Originally Posted by ThunterBR

I Make the Script for Select Ranking TOP Levels
***********************************************

 Spoiler

<?php 

    $host = "(local)"; // your sql instance 
    $user = "sa"; // username 
    $pw = ""; // password 
    $db = "Telecaster"; // db 
    $md5_key = "2011"; // your md5 key 
    $num = "15"; // num TOP
    $connect = mssql_connect($host,$user,$pw) 
    or die("Can't connect to the datebase."); 
     
    mssql_select_db($db,$connect) 
    or die("Can't select the datebase"); 

?> 
<center>
<h1>Ranking - Top <?php echo $num;?></h1><hr /><br />
<?php
//Created by Admin Thunder
echo '<div align="center"><table width="30%" border="1" bgcolor="#EEEEEE" style="text-align:center;">';
            echo '<td width="5%" bgcolor="#FFFFFF"><b>Rank';
            echo '<td width="25%" bgcolor="#FFFFFF"><b>Name';
            echo '<td width="25%" bgcolor="#FFFFFF"><b>Level';
            echo'</tr>';
            $rank=1;

						$getrank = mssql_query('SELECT TOP '.$num.' * FROM dbo.Character ORDER BY lv DESC');
            
    while ($consulta = mssql_fetch_assoc($getrank)) {
    $nameid = $consulta['name'];
    $getleader = mssql_query('SELECT name FROM dbo.Character WHERE name = "'.$nameid.'" AND lv = "0"');
    
    while ($leaderid = mssql_fetch_assoc($getleader)) {
    $uid = $leaderid['lv'];
    }
            echo '<tr><td  bgcolor="#FFF0F0">'.$rank.'</td>';
            echo '<td  bgcolor="#FFF0F0">'.$consulta['name'].'</td>';
            echo '<td  bgcolor="#FFF0F0">'.$consulta['lv'].'</td>';
            $rank++;
            }
//******** 
?>
</table>

nice :P ty , but what's in the "//******** " o.O"