[Issvar]

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