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