I'm having trouble fixing this pagination error on my site The pages keep adding on - I'm trying to limit the pages to 15 and then the 'Next' button. Anyone able to help - much appreciated Thanks Code: <? class Paging { var $sql; var $rs; var $numrows; var $limit; var $noofpage; var $offset; var $page; var $style; var $parameter; var $activestyle; var $buttonstyle; function Paging($query) { $this->offset=0; $this->page=1; $this->sql=$query; $this->rs=mysql_query($this->sql); $this->numrows=mysql_num_rows($this->rs); } function getNumRows() { return $this->numrows; } function setLimit($no) { $this->limit=$no; } function getLimit() { return $this->limit; } function getNoOfPages() { return ceil($this->noofpage=($this->getNumRows()/$this->getLimit())); } function getPageNo($ext_param="") { $str=""; $str=$str."<table width='100%' border='0'><tr>"; $str=$str."<td align='left' valign='top'>"; if($this->getPage()>1) { if($ext_param!="") { $str=$str."<a href='".$_SERVER['PHP_SELF']."?$ext_param&page=".($this->getPage()-1).$this->getParameter()."' class='".$this->getStyle()."'>Back</a> "; } else { $str=$str."<a href='".$_SERVER['PHP_SELF']."?page=".($this->getPage()-1).$this->getParameter()."' class='".$this->getStyle()."'>Back</a> "; } } for($i=1;$i<=$this->getNoOfPages();$i++) { if($i==$this->getPage()) { $str=$str."<span class='".$this->getActiveStyle()."'>".$i." </span>"; } else { if($ext_param!="") { $str=$str."<a href='".$_SERVER['PHP_SELF']."?$ext_param&page=".$i.$this->getParameter()."' class='".$this->getStyle()."'>".$i."</a> "; } else { if($ext_param!="") { $str=$str."<a href='".$_SERVER['PHP_SELF']."?$ext_param&page=".$i.$this->getParameter()."' class='".$this->getStyle()."'>".$i."</a> "; } else { $str=$str."<a href='".$_SERVER['PHP_SELF']."?page=".$i.$this->getParameter()."' class='".$this->getStyle()."'>".$i."</a> "; } } } } if($this->getPage()<$this->getNoOfPages()) { if($ext_param!="") { $str=$str."<a href='".$_SERVER['PHP_SELF']."?$ext_param&page=".($this->getPage()+1).$this->getParameter()."' class='".$this->getStyle()."'>Next</a>"; } else { $str=$str."<a href='".$_SERVER['PHP_SELF']."?page=".($this->getPage()+1).$this->getParameter()."' class='".$this->getStyle()."'>Next</a>"; } } $str=$str."</td>"; $str=$str."<td align='right' valign='top' class='".$this->getStyle()."'>"; $str=$str."</td>"; $str=$str."</tr></table>"; print $str; } function getOffset($page) { if($page>$this->getNoOfPages()) { $page=$this->getNoOfPages(); } if($page=="") { $this->page=1; $page=1; } else { $this->page=$page; } if($page=="1") { $this->offset=0; return $this->offset; } else { for($i=2;$i<=$page;$i++) { $this->offset=$this->offset+$this->getLimit(); } return $this->offset; } } function getPage() { return $this->page; } function setStyle($style) { $this->style=$style; } function getStyle() { return $this->style; } function setActiveStyle($style) { $this->activestyle=$style; } function getActiveStyle() { return $this->activestyle; } function setButtonStyle($style) { $this->buttonstyle=$style; } function getButtonStyle() { return $this->buttonstyle; } function setParameter($parameter) { $this->parameter=$parameter; } function getParameter() { return $this->parameter; } } ?> Code (markup):