Hi everybody
I have problem with transferring the key to the next page when i split the results in multiple pages...can somebody tell me what is the problem....Thank you
p.s. i think the problem is with these kind of lines
$next = " <a href=\"$self?page=$page&key=$key\"><font face='Verdana' size='2'>Next</font></a> "; lines
Thank you again
// how many rows we have in database
$query = "SELECT COUNT(title) AS numrows FROM papernew
where title LIKE '%".$key."%' ";
$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 .= "<font face='Verdana' size='4' color=red> $page </font>"; // no need to create a link to current page
}
else
{
$nav .= " <a href=\"$self?page=$page&key=$key\"><font face='Verdana' size='2'>$page</font></a>";
}
}
// creating previous and next link
// plus the link to go straight to
// the first and last page
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " <a href=\"$self?page=$page&key=$key\"><font face='Verdana' size='2'>Prev</font></a> ";
$first = " <a href=\"$self?page=1&key=$key\"><font face='Verdana' size='2'>First Page</font></a> ";
}
else
{
$prev = ' '; // we're on page one, don't print previous link
$first = ' '; // nor the first page link
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " <a href=\"$self?page=$page&key=$key\"><font face='Verdana' size='2'>Next</font></a> ";
$last = " <a href=\"$self?page=$maxPage&key=$key\"><font face='Verdana' size='2'>Last Page</font></a> ";
}
else
{
$next = ' '; // we're on the last page, don't print next link
$last = ' '; // nor the last page link
}
// print the navigation link
echo "<p align=center> $first $prev $nav $next $last </p>";
