Control table display with php & Postgresql?

[tomycon]

I'm running a small office intranet with postgresql database and accessing it with php. I'm able to contruct web pages that can add to the database and display a table with results from a query to the db. However, as the db has grown, a simple query can return 100+ legit responses, which makes for a very long scroll on the web page, not to mention printing!
How can I limit the display to 10+/- items per page, then have a button that will display next 10, or previous 10? Obviously there are tons of web sites out there that do this sort of thing, I can't seem to decipher it looking at "page source code".

any help would be great! thanks!

[Admin]

use SQL like this

first page:
select * from TABLENAME limit 0,10;

second page:
select * from TABLENAME limit 10,10;

third page:
select * from TABLENAME limit 20,10;


i would probaly do something like this in my php:

$start = $start + 10;

pass $start from the first page to all subpages

[redhead]

This is what I do:

function reducer($where)
{
   global $argv;
   $argv_intern = implode($argv,"+");
   if(!ereg("startat=", implode($argv, "+")))
     return $argv_intern."&startat=$where";
   return ereg_replace("startat=[0-9]*", "startat=$where", $argv_intern);
}

function print_links($lang="uk", $full="0", $order="id")
{
  global $DB_LINK, $PHP_SELF, $startat;
  if(!isset($startat))
    $startat = 0;
  $limitquery="$startat, 10";
  $res=mysql_query("SELECT * FROM links WHERE countable = 0 ORDER BY $order DESC LIMIT $limitquery", $DB_LINK);  
  $size=mysql_num_rows($res);
  if($size != 0)
  {
    $limiter=10;
    if(!$full)
    {
      echo "<table border='0' cellspacing='1' cellpadding='1'>";
    }
    while($myrow=mysql_fetch_array($res))
    { 
       $pres = mysql_query("SELECT display_name FROM user WHERE id=$myrow[user_id]", $DB_LINK);
       $row = mysql_fetch_array($pres);
       print_links_entry($lang, $myrow[id], $myrow[created_date], $myrow[url], $myrow[description], $myrow[$user_id], $row[display_name], $myrow[click_count], $full);
    }
    if($full == 1)
    {
      echo "<br><font size='-1'><center>";
       if($startat > 0) 
       {
         echo "<a href='$PHP_SELF?".reducer($startat-$limiter)."'>";
         if($lang == "da")
           echo "$limiter Forige links</a>";
         else
           echo "Previus $limiter links</a>";
       }
       if(($startat+$limiter) == $size)
       {
         echo "<a href ='$PHP_SELF?".reducer($startat+$limiter)."'>";
         if($lang == "da")
           echo " &nbsp;  &nbsp; $limiter Næste links</a></font>";
         else
           echo " &nbsp;  &nbsp; Next $limiter links</a></font>";
       }
       echo "</center>";
    }
    if(!$full)
    {
      echo "</table>";
    }
  }
  else
  {
     echo "
         <font size='+1'>
          <p>
          There wasn't found any entries.
          <p>
         </font>
         ";
  }
}

Just to give you a hint... As Admin said, its the $startat combined with the sql-function LIMIT

Now this is not directed towards a postgreSQL database, but I think php uses a psql_* function intead of mysql_*