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); }