//**************************************
    //     
    // Name: previous next(working)updated a
    //     lready
    // Description:i set this code up to kee
    //     p from having to rewrite sql code.
    as well as a having previous next on my search results. this code
    could be expanded on for many other things.
    this should cut your code way down. on repeating mysql statements.
    this is just my version for previous next.
    i have not found any bugs in it as of yet except now and then there
    may be a blank page at the end of results.
    of your max results is only 1 then the last page will be blank.
    i have only tested to 25 and else it seems to work fine.
    let me know of any bugs you see in it and find other than what i stated.
    i have fixed the blank page at the end on some listing by using $pages=ceil($num_result1/$max);
    rather than using number_format();this should be exceptional now.
    // By: cpsim
    //
    // Inputs:see code
    //
    //This code is copyrighted and has    // limited warranties.Please see http://
    //     www.Planet-Source-Code.com/xq/ASP/txtCod
    //     eId.742/lngWId.8/qx/vb/scripts/ShowCode.
    //     htm    //for details.    //**************************************
    //     
    
    <?php
    //i set this code up to keep from having
    //     to rewrite sql code.
    //as well as a having previous next on m
    //     y search results. this code
    //could be expanded on for many other th
    //     ings.
    //this should cut your code way down. on
    //     repeating mysql statements.
    //this is just my version for previous n
    //     ext.
    //i have not found any bugs in it as of 
    //     yet except now and then there
    //may be a blank page at the end of resu
    //     lts.
    //of your max results is only 1 then the
    //     last page will be blank.
    //i have only tested to 25 and else it s
    //     eems to work fine.
    //let me know of any bugs you see in it 
    //     and find other than what i 
    //stated. will have a sourcecode section
    //     at my site soon.
    //if you expand on this code i would lik
    //     e a copy of it.
    //cuddlenlv@yahoo.com
    //http://nb-ware.com
    //must classify your max results
    $max=10;
    $page1=$page;
    $pagea=$page*$max;
    //must classify $criteria and place
    $critteria1="LIMIT $pagea,$max";
    $place="products";
    $action=getenv("QUERY_STRING");
    If ($action==""){
    $page=0;
    $max=2;
    }
    //this shows the statistics of the resul
    //     ts
    	$st=connects();
    	$resa=selectdata($place,'');
    	$numres1=numres($resa);
    	closea($st);
    	echo $page1*$max+1; 
    	echo " - ";
    	if ($max*$page2 > $numres1){
    		echo $numres1;
    	}
    	if ($max*$page2 < $numres1){
    		echo $max*$page2;
    	}
    	echo " Of ";
    	echo $numres1;
    	echo " Results <br><hr>";
    //the small bit of code to work it	
    	$st=connects();	
    	$resa=selectdata($place,$critteria1);
    	$numres=numres($resa);
    	for ($is = 0;$is <= $numres-1;$is++) {
    	$line = mysql_fetch_array($resa);
    	print "$line[name]<br>";
    	}
    	closea($st);
    	$st=connects();
    	getthedata($place,'',$max,$page,$page1,$PHP_SELF);
    	closea($st);
    //end of small bit of code
    //the rest can reside in another file as
    //     long as it is included some where in the
    //     page.
    //funtions
    function connects(){
    //connects to mysql database
    	//here you need the server'localhost' your 'username' and 'password'
    	$connection = mysql_connect('servername or address', 'username', 'password') or die("Connection error!");
    	$db1="dbase";
    	mysql_select_db($db1, $connection);
    	return($connection);
    }
    function selectdata($place,$critteria1){
    //selects database from database
    	$query = "SELECT * FROM $place $critteria1";
    	$result = mysql_query($query) or die("ERROR");
    	return($result);
    }
    function numres($result){
    //returns number result
    	$num_result = mysql_num_rows($result);
    	return($num_result);
    }
    function closea($st){
    //closes mysql database
    	mysql_close($st);
    }
    function getthedata($place,$criteria,$max,$page,$page1,$PHP_SELF){	
    //gets complete data
    	$query = "SELECT * FROM $place $criteria";
    	$result = mysql_query($query) or die("ERROR");
    	$num_result1 = mysql_num_rows($result);
    	$pages=ceil($num_result1/$max);
    //previous stuff
    	if ($page>0){
    		echo "<a href='$PHP_SELF?page=";
    		echo $page-1;
    		echo "'><< Prev</a> ";
    	}else{
    	}
    //current stuff
    	for ($it=1;$it <= $pages;$it++){
    		if ($it==$page1+1){
    			echo $it;
    			echo " ";
    		}else{
    			print "<a href='$PHP_SELF?page=";
    			print $it-1;
    			print "'>$it</a> ";
    		}
    	}
    //next stuff
    	if ($page<$pages-1){
    		echo "<a href='$PHP_SELF?page=";
    		echo $page+1;
    		echo "'>Next >></a> ";			
    	}else{
    	}
    }
    ?>