[RESOLVED] paging not working right, does not change results

[spiritssight]

Hello All,

I have created a function for paging, it works as should but the results on the page stay the same as if it still page one below are the two files:

search_display.php

<?php

if(empty($_GET['sq'])) // if there is no ?sq=... whatever then this displays
{
include '/home/dev/www/qna/search_form.php';
include '/home/dev/www/qna/qna_common.php';
}
else // if there is ?sq=... whatever then this displays
{
include '/home/dev/www/lib/page_nav_bar.php';

include '/home/dev/www/qna/search_form.php';

$searchquery = $_GET['sq'];

if(isset($_GET["pn"]))
{ $pagenumber = $_GET["pn"]; } else { $pagenumber = 1; }

if(isset($_GET["rpp"]))
{ $recordsperpage = $_GET["rpp"]; 	} else { $recordsperpage = 20; }



include '/home/dev/www/search/lib/db_config_ro-dev.php';
include '/home/dev/www/search/lib/db_conn-select.php';

$offset = ceil(($pagenumber - 1) * $recordsperpage);

// how many rows we have in database
$query = " SELECT * FROM query WHERE pno LIKE '%$searchquery%'";
$result = mysql_query($query) OR die("Was unable to get the results!" . mysql_error());
$totalrecords = mysql_num_rows($result) OR die("Was unable to get number of rows" . mysql_error());

//$sql_a = " SELECT SQL_CALC_FOUND_ROWS * FROM query WHERE pno LIKE '%$searchquery%' LIMIT $offset, $recordsperpage";
$sql_a = " SELECT * FROM query WHERE pno LIKE '%$searchquery%' LIMIT $offset, $recordsperpage";
$results = mysql_query($sql_a) OR die("Was unable to get the results!" . mysql_error());
$rows = mysql_num_rows($results) OR die("Was unable to get number of rows" . mysql_error());
// $sql_b = "SELECT FOUND_ROWS()";
// $totalrecords = mysql_query($sql_b);


echo "<center>" . page_bar($searchquery, $totalrecords, $pagenumber) . "</center>";

echo " Your search for ". $searchquery ." found ". $totalrecords."<br /><br />";

$i=0;
	while ($i < $rows) {

$ein=mysql_result($result,$i,"EIN");
$pno=mysql_result($result,$i,"PNO");
$state=mysql_result($result,$i,"STATE");
$ntee_code=mysql_result($result,$i,"NTEE_Code");
$activity_code=mysql_result($result,$i,"Activity_Code");
$sn=mysql_result($result,$i,"SN_SNL");

$rn = $i + 1;

echo "Record #: ".$rn.": ". $pno ." -- ".$state." -- ".$ein."<br />";
echo $ntee_code ." -- ". $activity_code ." -- ". $sn ."<br /><br />";

$i++;
}

echo "<center>" . page_bar($searchquery, $totalrecords, $pagenumber) . "</center>";

include '/home/dev/www/lib/db_close.php';
} // close the else statement for displaying the search box with results
?>

page_nav_bar.php

<?php

// $searchquery = "test"; // var from url
// $totalrecords = 172; // total rows found from the search
// $pagenumber = $_GET['pn']; // page number that is being displayed

function page_bar($searchquery, $totalrecords, $pagenumber = '1', $recordsperpage = '20')
{
$firstpage = 1; // first page
$lastpage = ceil($totalrecords/$recordsperpage); // last page

$page_nav_bar = ''; // var thats used to hold what will be displayed for the page nav bar

if($pagenumber > $firstpage)
{
$page_nav_bar .= "<a href=\"http://" . $_SERVER['SERVER_NAME'] . $_SERVER['PHP_SELF'] ."?sq=$searchquery&pn=$firstpage\">First</a> ";
$page_nav_bar .= ' | ';
$prevpage = $pagenumber - 1;
$page_nav_bar .= "<a href=\"http://" . $_SERVER['SERVER_NAME'] . $_SERVER['PHP_SELF'] ."?sq=$searchquery&pn=$prevpage\">Prev</a> ";
}

$page_nav_bar .= " Page $pagenumber of $lastpage ";

if($pagenumber < $lastpage)
{
$nextpage = $pagenumber + 1;
$page_nav_bar .= "<a href=\"http://" . $_SERVER['SERVER_NAME'] . $_SERVER['PHP_SELF'] ."?sq=$searchquery&pn=$nextpage\">Next</a>";
$page_nav_bar .= ' | ';
$page_nav_bar .= "<a href=\"http://" . $_SERVER['SERVER_NAME'] . $_SERVER['PHP_SELF'] ."?sq=$searchquery&pn=$lastpage\">Last</a>";
}

$page_nav_bar .="
		<form name=\"goto_page\" action=\"". $_SERVER['PHP_SELF']."\" method=\"GET\">
		<input type=\"hidden\" name=\"sq\" value=\"$searchquery\" />
		 Goto page: <input type=\"text\" name=\"pn\" size=\"1\" maxlength=\"2\" />
			<input type=\"submit\" name=\"go\" value=\"Go\" />
		</form>";

return "$page_nav_bar";
}

// echo "<center>" . page_bar($searchquery, $totalrecords, $pagenumber) . "</center>";

?>

please assist with this, thanks!

Sincerely,
christopher

[spiritssight]

ok, I now have played with this more, I have echoed out the sql_a and it shows it correctly, I have ran the query that it shows in mysql and it returns the correct results, so the question is why would it not change, I put the echo right above the Results line where it says found ... results and when I hit next page the number in the query change as should but the results don't change it stays on page one results

strange (head shakes)

please help with this!

Sincerely,
Christopher

[spiritssight]

its fixed, I realized, I relooked again again, and then I thought about the way that it was being displayed and it clicked that maybe I did not do that write so I changed it and added a fetch thing in there and it now works with a couple of other fixes

Sincerely,
Christopher