Pos |
Name |
Points |
Behind |
$query = 'SELECT * , sum( score ) FROM `careerpoints` GROUP BY name ORDER BY `sum( score )` DESC ';
$result=mysql_query($query);
$fnum=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $fnum) {
//$st=0;
$p=$i-1;
$spleader=mysql_result($result,0,"sum( score )");
$rname=mysql_result($result,$i,"name");
$points=mysql_result($result,$i,"sum( score )");
$pb=mysql_result($result,$p,"sum(score)");
$behind=$spleader-$points;
$extra=1 ;
$pos=$i+$extra ;
?>
echo "$pos"; ?> |
echo "$rname"; ?> |
echo "$points"; ?> |
echo "$behind"; ?> |
++$i;
}
echo " ";
?>
|