[Jaffizzle]

eeh here ya go i just wrote a script for ya.

PHP Code:

<?php
/* ALOT OF THE CONFIGS CAN BE CHANGED IN THE CONSTRUCTOR */

include ("pagination.inc.php");
/*db stuff goes here */
$pgtn = new pagination; 
$pgtn->sql="SELECT * FROM some_table";  //sql
$pgtn->per_page=5;  //number of listings per page
$pgtn->constructor($_GET['page'], "page");  //if you wish to change your var..ie [url]www.somesite.com?page=1[/url] to [url]www.somesite.com?id=1[/url]
$limit = $pgtn->limit();  //executes query and returns result
while ($row=mysql_fetch_assoc($limit)){  //displays the result
    echo $row['some_info']."<br>";
}
    
$pgtn->display_pages();  //displays the pagination
?>

heres the class file...
pagination.inc.php

PHP Code:

<?php
//pagination class
class pagination{
var $sql;
var $start;
var $page;
var $total_pages;
var $pagevar;
var $per_page;
var $limit_pages;


function constructor($getpage, $page_var){ //$page = $_GET['page'];
if(empty($getpage))
    $this->page=1;
else
    $this->page=$getpage;
if(empty($this->pagevar)) $this->pagevar = $page_var;
else
    $this->pagevar="page";
$this->start=$this->page*$this->per_page-$this->per_page;

$result=mysql_query($this->sql) or die(mysql_error());
$total_rows=mysql_num_rows($result);
if($total_rows%$this->per_page==0)
    $this->total_pages = $total_rows/$this->per_page;
else
    $this->total_pages = $total_rows/$this->per_page+1;

//$this->limit_pages=$this->page-$this->per_page;
//$this->limit_pages_end=$this->total_pages;
$this->limit_pages=$this->page-5;  //start  pages  start with current page - 5
$this->limit_pages_end=$this->page+5;  //end page  end with current page + 5
}

function limit()
{
    $result=mysql_query($this->sql." LIMIT ".$this->start.", ".$this->per_page);
    return $result;
}

function display_pages(){
if($this->page > 1)
    echo "<a href=\"".$_SERVER['PHP_SELF']."?".$this->pagevar."=".($this->page-1)."\"><< </a>";
else
    echo "<< ";
    
for($i = $this->limit_pages; $i <= $this->limit_pages_end; $i++){  //use to limit how many pages displayed
        if($i < 1){
            echo"";
        }elseif ($i > $this->total_pages){
            echo"";
        }elseif($i == $this->page){
            echo $i."&nbsp;";
        }else{
           echo "<a href=\"".$_SERVER['PHP_SELF']."?".$this->pagevar."=".$i."\">$i </a>";
        }
    } 
    
if($this->page <= $this->total_pages)
    echo "<a href=\"".$_SERVER['PHP_SELF']."?".$this->pagevar."=".($this->page+1)."\">>> </a>";
else
    echo ">> ";
     }
}

?>

sorry about the lack of comments..i hate commenting


but lemme know how it goes!