Use the LIMIT option in mysql, and make a next and previous link that contain 10 more or less than the current limit.
PHP Code:
<?
$server= "myserver";
$user= "myaccount";
$password= "pass";
$database= "database1";
$table= "table1";
MYSQL_CONNECT($server, $user, $password) or die ( "<H3>Server unreachable</H3>");
MYSQL_SELECT_DB($database) or die ( "<H3>Database non existent</H3>");
if(!isset($limit) || !is_numeric($limit)) $limit=0;
mysql_query("SELECT * FROM $table order by name LIMIT $limit,10");
while($row = mysql_fetch_row($result))
{
print (" $row[0] ");
print (" $row[1] ");
print (" $row[2] ");
}
$nextlimit=$limit+10;
echo "<a href=\"$_SERVER['PHP_SELF']?limit=$nextlimit\">next</a>";
$prevlimit=$limit-10;
if ($prevlimit<0) $prevlimit=0;
echo "<a href=\"$_SERVER['PHP_SELF']?limit=$prevlimit\">previous</a>";
?>