$limit = 25; $query_count = "SELECT count(*) FROM Notebooks WHERE $clause"; $result_count = mysql_query($query_count); $totalrows = mysql_num_rows($result_count); echo "Search Results for: $clause

"; 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("Prev ".$limit." "); } else { echo("Prev ".$limit." "); } $numofpages = $totalrows / $limit; for($i = 1; $i <= $numofpages; $i++){ if($i == $page){ echo($i." of ".$i++); }else{ echo("$i "); } } if(($totalrows % $limit) != 0){ if($i == $page){ echo($i." of ".$i++); }else{ echo("$i of $i++"); } } if(($totalrows - ($limit * $page)) > 0){ $pagenext = $page++; echo("Next ".$limit.""); } else { echo("Next ".$limit); }