page numbers

[Butthead]

I'm making a script that searches a mysql db for past billing statements. How would one go about having page numbers for the returned results?

something like

<?PC (pseudo code)

if ($results > $resultsperpage){
while ($results){
split_up_results_to_many_pages();
print $html;
}
}

?>

[tuf-web_co_uk]

try searching for 'page numbering', the correct teminology is actually 'pagination'

cant find anything?

<?php

function pagination($qry, $link_add) {

	$query = $qry;

	$result = mysql_query($query, $conn) or die(mysql_error());

	$num_results_pn = mysql_num_rows($result);

	$pageid = $_GET['pageid'];
	if (empty($pageid)) {
		$pageid = 1;
	}
	$pageid = substr($pageid, 0, 3); // or however big page max is 
	$pageid = EscapeShellCmd($pageid); 

	$rowcnt = $_GET['rowcnt'];
	if (empty($_GET['rowcnt'])) {
		$rowcnt = $num_results_pn;
	}
	$rowcnt = substr($rowcnt, 0, 6); // or however big max rows is 
	$rowcnt = EscapeShellCmd($rowcnt); 

	$searchp = $_GET['searchp'];
	if (empty($_GET['searchp'])) {
		$searchp = 0;
	}
	$searchp = substr($searchp, 0, 50); // or whatever length 
	$searchp = EscapeShellCmd($searchp); 

	// build query - using 10 recs per page 
	$skiprows = (($pageid - 1) * 10); // number of rows to skip in query

	// Enter Query

	$query = $qry." LIMIT $skiprows, 10"; 

	$result = mysql_query($query, $conn) or die(mysql_error());

	$numrows = mysql_num_rows($result); 
	if ($numrows > 0) { 
		for ($i = 1; $i <= 10; $i++) {  
			if ($row = @ mysql_fetch_array($result)) {
				$this->get_entries($row);
			}
		}
	}
	else {
		echo "No results found";
	}



	// NUMBERS LIST 1,2,3,4 NEXT >>

	echo "<p>";

	// if not on page 1, then do previous 
	if ($pageid > 1) { 
		$oldpageid = $pageid - 1;
		echo "<a href=\"".$_SERVER['SCRIPT_NAME']."?".$link_add."&pageid=1\" class=\"bread\" title=\"First\">"; 
		echo "<<  </a>";  
		echo "<a href=\"".$_SERVER['SCRIPT_NAME']."?".$link_add."&pageid=$oldpageid\" class=\"bread\" title=\"Previous\">"; 
		echo "<  </a>"; 
	} 

	// now put out 10 pages worth of links 
	$maxpage = ceil($rowcnt / 10); // largest page 
	if ($maxpage < 10) { 
		$pagespread = $maxpage - 1; 
		$midpoint = floor($maxpage / 2); 
	} 
	else { 
		$pagespread = 9; 
		$midpoint = 4; 
	} 

	// set the starting and ending page numbers 
	$lopage = $pageid - $midpoint; 
	if ($lopage < 1) { 
		$lopage = 1; 
	} 
	$hipage = $lopage + $pagespread; 
	if ($hipage > $maxpage) { 
		$hipage = $maxpage; 
		$lopage = $hipage - $pagespread; 
	} 

	// now put out the ten (or less) links 
	for ($i = $lopage; $i <= $hipage; $i++) { 
		if ($pageid == $i) { 
			echo "  <font class=\"bread\"><u>$i</u>  "; 
		} 
		else { 
			echo "<a href=\"".$_SERVER['SCRIPT_NAME']."?".$link_add."&pageid=$i\" class=\"bread\" title=\"Page $i\">"; 
			echo "  $i  </a>"; 
		} 
	} // for all links 

	// finally, put out the next link if not last page 
	if ($pageid  < $maxpage) { 
		$newpageid = $pageid + 1; 
		echo "<a href=\"".$_SERVER['SCRIPT_NAME']."?".$link_add."&pageid=$newpageid\" class=\"bread\" title=\"Next\">"; 
		echo "  ></a>";
		echo "<a href=\"".$_SERVER['SCRIPT_NAME']."?".$link_add."&pageid=$maxpage\" class=\"bread\" title=\"Last\">"; 
		echo "  >></a>";  
	}

	echo " <font class=\"bread\">($maxpage Pages)";

}

?>

when you call it specify the query you want as $qry

and $link_add adds any additional information to the link which you need for the query, eg &search_term=pagination

should be pretty simple