when you say "top 10" .. what are you using as the element of measurement? is it number of posts? the above example is for random 10, .. the one below would be for top 10 if the field you are basing this on is number of posts.
PHP Code:
<?
$result = mysql_query("select * from members order by posts desc limit 10");
?>