order by (Opgelost)

$query = mysql_query ( "SELECT points FROM clans ORDER BY points DESC" ) or die (mysql_error());
$i = 1;
while ( $array = mysql_fetch_array($query) )
{
echo 'rank: '.$i.' - points: '.$array['points'];
$i = $i + 1;
}

$query = mysql_query ( "SELECT points FROM clans ORDER BY points DESC" ) or die (mysql_error());
$i = 1;
while ( $array = mysql_fetch_array($query) )
{
echo 'rank: '.$i.' - points: '.$array['points'];
$i = $i + 1;
}