$query = mysql_query("SELECT * FROM `users` WHERE 1 ORDER BY `money` DESC LIMIT 0, 30 "); while($user = mysql_fetch_array($query)) { echo "$user[username] has $user[money] money.<br>"; }