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'){

// 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