[Resolved] Top 10 members

[klik]

Hi,

I would like a function to display the top 10 members with the top 10 points.

Obviously member with the most points to be displayed at the top.

So, i would like a username and points tally for each top 10 member to appear.

The code i have currently is below.

function top_ten_members()
{
    // Counting Number of Members:
    $result = @mysql_query("SELECT username, user_points FROM cms_users ORDER BY user_points DESC LIMIT 10");
    // To display top 10 members:
    echo "<b>Top Members: <font type=\"arial\", color=\"#FDBA19\">" . mysql_result($result, 0) . "</font></b>";
}

Thanks for your help in advance.

[devinemke]

$result = mysql_query('SELECT username, user_points FROM cms_users ORDER BY user_points DESC LIMIT 10');
echo 'Top 10 Members:<br><br>';
while ($row = mysql_fetch_assoc($result))
{
	echo $row['username'] . ': ' . $row['user_points'] . '<br>';	 
}

[klik]

Thanks mate🙂