Mentioned below is a PHP  function , which can be used to navigate pages generated from  the select query . ie. in the form of  << Previous ||  Next  >>

<?


function PagerNextPrevious(&$sql,$pagesize,$class='txt'){
// http://www.hanusoftware.com
// Set Default Page Size to 20
    if($pagesize=="")
     $pagesize=20;
$page=get_post('page');
if($page!='NA'){
   $beg=($page-1)*$pagesize;
    $end=$pagesize;
  }else{
     $beg=0;
    $end=$pagesize;
   $page=1;
  }
    $rs=mysql_query($sql) ;
$nrows=mysql_num_rows($rs);
$sql=$sql." limit $beg,$end";
$rs=mysql_query($sql);
$subrows=mysql_num_rows($rs); 
   
if($nrows!=0){
  $from=(int)($beg)+1;
  $totalpages=(int)($nrows/$pagesize);
  $frac=($nrows/$pagesize);
  if(($frac-$totalpages)>0)
   $totalpages+=1;
  echo "( Page $page of $totalpages )&nbsp; &nbsp;&nbsp; ";
     if($page>1 ){
      echo "<a class=$class href='".selfq()."&page=".($page-1)."'> &lt;&lt;Previous   </a>";
     }
     $next=$page+1;
     if($next <=$totalpages ){
     
      echo "&nbsp;&nbsp;&nbsp;<a class=$class href='".selfq()."&page=".$next."'> Next &gt;&gt;  </a>";
     }
   
    }
}

// Assuming you have Opened  connection to mysql database.

$sql=" Select * from Products ";

//  Show the pager link in form of Previous||Next

PagerNextPrevious($sql,20,'text');

$rs=mysql_query($sql);
if(mysql_num_rows($rs)>0){
while($row=mysql_fetch_array($rs)){
  echo $row["ProductName"]."<br>";
 
}
}




?>

Software Development India