Hiya,
How do I add pagination to the following code, so that information is retrieved from the database, 10 records at a time? Page number links should also be provided to go to the PREVIOUS or NEXT page, or directly to a page (e.g Page 6)
Example:
PREVIOUS 1 2 3 4 5 6 7 8 9 10 NEXT
<?php
mysql_select_db("db", $con);
$result = mysql_query("SELECT * FROM users");
while($row = mysql_fetch_array($result))
{
echo $row['First Name'] . " " . $row['Last Name'];
echo "<br />";
}
mysql_close($con);
?>