$result = mysql_query("SELECT userid,username,posts FROM user ORDER BY posts DESC LIMIT 10"); while ($s = mysql_fetch_array($result, MYSQL_NUM)){.......your work here......}