| Name: | |
| Email: | |
| Location: | |
| Comments: | |
| "; ?> |
Sorry, but we did not receive either your name or comments. Please go back and re-enter them.
"; else { echo ""; // Set page numbers if (!$page) $offset = 0; else $offset = (($LimitOfItems * $page)-$LimitOfItems); $gbquery = "SELECT * FROM " .$DB_Prefix ."_guestbook WHERE Date<>'0000-00-00' ORDER BY ID DESC"; $totalgbquery = $gbquery; $gbquery .= " LIMIT $offset, $LimitOfItems"; $gbresult = mysql_query($gbquery, $dblink) or die ("Unable to select totals. Please try again later."); $totalgbresult = mysql_query($totalgbquery, $dblink) or die ("Unable to access total records."); $totalgbnum = mysql_num_rows($totalgbresult); if ($totalgbnum > 0) { // START FORMATTING OF PAGE NUMBERS $offset = ($page-1)*$LimitOfItems; if ($totalgbnum % $LimitOfItems == 0) $page_count = ($totalgbnum-($totalgbnum%$LimitOfItems)) / $LimitOfItems; else $page_count = ($totalgbnum-($totalgbnum%$LimitOfItems)) / $LimitOfItems + 1; $previous = $page - 1; $next = $page + 1; if ($page_count > 1) { $i = 1; $n = 3; if ($page < $n+1) $pagestart = 1; else if ($page > ($page_count-$n)) $pagestart = $page_count-$n*2; else $pagestart = $page-$n; while ($i <= $page_count) { if (($i >= $pagestart) AND ($i <= $n*2+$pagestart)) { if ($i != $page) $output_string .= "$i"; else $output_string .= "$i"; if ($i != $page_count AND $i != $n*2+$pagestart) $output_string .= " | "; } $i++; } } // END FORMATTING OF PAGE NUMBERS // START DISPLAY OF PAGE NUMBERS if ($page_count > 1) { if ($Page_Numbers == "Yes") { echo "";
if ($page > 1)
{
echo "<< | ";
echo "< | ";
}
echo "$output_string";
if ($page < $page_count)
{
echo " | >";
echo " | >>";
}
echo "
Page $page of $page_count";
echo "
"; if ($page > 1) echo "<< First | < Previous | "; echo "Page $page of $page_count"; if ($page < $page_count) echo " | Next > | Last >>"; echo "
"; } } // END DISPLAY OF PAGE NUMBERS echo "| ";
if ($Line_Color)
echo " "; else echo " "; echo " | |
| ";
if ($Line_Color)
echo " "; else echo " "; echo " | ";
echo "|