hjælp til php
jeg har det php script den lister de 15 beste person på min hlstats alså bare en top15det ser så ud
<?php
/***********************************************************************************************/
/* Top 5 Script*********************************************************************************/
/*Sutekh****************************************************************************************/
/*Sutekh@subdimension.com***********************************************************************/
/***********************************************************************************************/
$dbhost="localhost"; //mysql host address
$dbuname="xxx"; //mysql user name
$dbpass="xxxxxx"; //mysql user pass
$dbname="hlstats"; //hlstats db name
mysql_connect($dbhost, $dbuname, $dbpass) or die ("Unable to connect to mysql server");
$db=mysql_select_db($dbname) or die ("Unable to select database");
$result = mysql_db_query($dbname,"
SELECT
lastName,
skill
FROM
hlstats_Players
where
hideranking = 0
ORDER BY
skill DESC");
?><table width="200"><tr><td width="200" align="left"><font size=4><b><u>Name</b></u></font></td><td width="20" align="right"><font size=4><b><u>Skill</b></u></font></td></tr></table><?
while ($i!=15 && $data = mysql_fetch_object($result)) {
?><table width="200"><TR>
<TD width="200" ALIGN="left"><font size=3><a href="http://com.diblo.dk/hlstats/hlstats.php?mode=search&game=cstrike&st=player&q=
<? print_r($data->lastName);?>">
<?php
//Set to however many characters you would like to show in players name
//
$show_length = 30;
//
//
if(strlen($data->lastName)>$show_length){
$data->lastName = substr($data->lastName, 0, $show_length);
$data->lastName .= "..";
}
echo ($data->lastName);?></a></font></td><td width="20" ALIGN="right"><font size=3><? print_r($data->skill);?></font></td>
</tr></table><?
$i++;
}
echo "";
$db=mysql_close ();
?>
du kan se den i funksjon her:
http://com.diblo.dk/hlstats/top.php
det jeg så vil gerne have er at den skriver 1. 2. 3. osv ud for person 1, 2 og 3 osv
