Paginate MYSQL Table

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.

PHP Code:

---

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);
?> 


---

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

Quote:

---

Originally Posted by penagate

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.

PHP Code:

---

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


---

Incase you wanted it.

Quote:

---

Originally Posted by Marthz

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.

PHP Code:

---

$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:

Quote:

---

Originally Posted by penagate

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.

:wave: