[SOLVED] limet query result (only thing i can think of for a name)

[richiec]

http://fearedwarlords.dks-gfx.com/

 

if you go there and look at the part which says "top potion hunters" it displays all found in the db but i only want it to return the top 10 this is my current code for that part of the site..

 

$query="SELECT * FROM `potions` ORDER BY (points+0) DESC";
$result=mysql_query($query) or die(hmm);
$num = mysql_num_rows($result);
$i=0;
echo '<div align="center">
<table width="160" border="0">
   <tr>
    </tr>
  <tr>
  </tr>
  ';
while ($i < $num) {
$rank = $i+1;
$name = mysql_result($result,$i,"name");

$i++;
echo "<tr>
<td><div align=\"center\"><b><font color=#00FF00> $rank </font>- <font color=#00FF00>$name</font></div></td>
  </tr>
";
}
echo '</table>
</div>';

 

does anyone have any ideas on how to only display the top 10?

[The Little Guy]

$query="SELECT * FROM `potions` ORDER BY (points+0) DESC LIMIT 10";

[richiec]

thanks, that was simple cant believe i didnt figure it out but thanks :x