Paginate MYSQL Table

[Marthz]

I've never really done this, and Im kinda stuck on it. Can anyone help me on how to paginate this table, with it only showing 10 results at a time.

echo "<table border='1'>

<tr>
<th>Rank</th>
<th>Name</th>
<th>Level</th>
<th>Fame</th>
<th>Job</th>
</tr>";
$number = 1;
while($row = mysql_fetch_array($result))
  {

  echo "<tr>";
    echo "<td>" . $number; $number = $number+1 . "</td>";
  echo "<td>" . $row['name'] . "</td>";
  echo "<td>" . $row['level'] . "</td>";
  echo "<td>" . $row['fame'] . "</td>";
  echo "<td>" . $jobs[$row['job']] . "</td>";
  echo "</tr>";
  }
echo "</table>";
mysql_close($con);
?> 

[penagate]

Use a LIMIT on your query to set upper and lower boundaries to the results.

[Marthz]

Use a LIMIT on your query to set upper and lower boundaries to the results.

Already have that, but that doesn't help me on knowing how to paginate it. I've never done it before, and there aren't really any good tutorials that I can find.

$result = mysql_query("SELECT * FROM Characters WHERE gm=0 ORDER BY Level DESC LIMIT 100"); 

Incase you wanted it.

[akhileshbc]

Already have that, but that doesn't help me on knowing how to paginate it. I've never done it before, and there aren't really any good tutorials that I can find.

$result = mysql_query("SELECT * FROM Characters WHERE gm=0 ORDER BY Level DESC LIMIT 100"); 

Incase you wanted it.

Marthz, you are missing the point. See this:

Use a LIMIT on your query to set upper and lower boundaries to the results.

Check this tutorials: http://www.phpeasystep.com/phptu/29.html

It is written using legacy mysql_* functions. After you get the idea, rewrite it using mysqli or PDO. And always avoid mysql_* functions.