All pastes #755910 Raw Edit

Pagination Issue

public php v1 · immutable
#755910 ·published 2007-10-31 00:06 UTC
rendered paste body
$limit = 25;               $query_count = "SELECT count(*) FROM Notebooks WHERE $clause"; $result_count = mysql_query($query_count);    $totalrows = mysql_num_rows($result_count); echo "<span class=\"textBold\">Search Results for: $clause </span><BR><br>";if(empty($page)){ 	$page = 1;      }$limitvalue = $page * $limit - ($limit); $query  = "SELECT * FROM Notebooks WHERE $clause LIMIT $limitvalue, $limit";        $result = mysql_query($query) or die("Error: " . mysql_error()); if ($page != 1){ 	$pageprev = $page--;	echo("<a href=\"nb_search_results.php?page=$pageprev\">Prev ".$limit."</a> ");  } else {	echo("Prev ".$limit." "); }$numofpages = $totalrows / $limit; for($i = 1; $i <= $numofpages; $i++){	if($i == $page){		echo($i." of ".$i++);	}else{		echo("<a href=\"nb_search_results.php?page=$i\">$i</a> "); 	}}	if(($totalrows % $limit) != 0){	if($i == $page){		echo($i." of ".$i++);	}else{		echo("<a href=\"nb_search_results.php?page=$i\">$i</a> of <a href=\"nb_search_results.php?page=$i++\">$i++</a>");	}} if(($totalrows - ($limit * $page)) > 0){	$pagenext = $page++;	echo("<a href=\"nb_search_results.php?page=$pagenext\">Next ".$limit."</a>");} else {	echo("Next ".$limit); }