i made this function for doing page numbering and it works very well except i need two values from it returned as variables for use elsewhere but i cant get them to return.
i need $offset and $rowsPerPage back from the function.
<?php
function page_numbering($rows, $table)
{
global $session;
// how many rows to show per page
$rowsPerPage = $rows;
// by default we show first page
$pageNum = 1;
// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
// how many rows we have in database
$query = "SELECT COUNT(`id`) AS numrows FROM `".$table."`";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);
// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nav .= "<span class=\"number_button_norm\">$page</span>"; // no need to create a link to current page
}
else
{
$nav .= "<span class=\"number_button\"><a href=\"$self?page=$page\">$page</a></span>";
}
}
/// page numbers
if ($numrows <= $rowsPerPage) {
//dont display page numbers//
}
else {
echo "<span class=\"story_pagenumber\"><span class=\"story_page_number\">Page number</span>".$nav."</span>";
}
// end page numbers
return $offset;
return $rowsPerPage;
}
page_numbering($rows=20, $table="storys");
echo $offset;
echo $rowsPerPage;
?>