[thelist] next, previous pagination
amar lastname
amarafzal at yahoo.com
Thu Mar 27 09:05:46 CST 2003
Hi
Got some code from a website. I can get the page to
display the number of records i want, displays the
number of pages and next link etc
Problem is when i click on the next button, the new
records dont display. The sql query used by the
tuttorial is:
SELECT * FROM your_table WHERE name LIKE '%". $query
."%'"); // the query.
Mine looks like:
$numresults = mysql_query("select * from $table_name
where job_sector = '$_POST[job_sector]' AND region =
'$_POST[region]'"); // the query.
the code for the next linkand back link look like:
<?
if ($page != 0) { // Don't show back link if current
page is first page.
$back_page = $page - $limit;
echo("<a
href=\"$PHP_SELF?query=$query&page=$back_page&limit=$limit\">back</a>\n");}
for ($i=1; $i <= $pages; $i++) // loop through each
page and give link to it.
{
$ppage = $limit*($i - 1);
if ($ppage == $page){
echo("<b>$i</b>\n");} // If current page don't give
link, just text.
else{
echo("<a
href=\"$PHP_SELF?query=$query&page=$ppage&limit=$limit\">$i</a>
\n");}
}
if (!((($page+$limit) / $limit) >= $pages) && $pages
!= 1) { // If last page don't give next link.
$next_page = $page + $limit;
echo("<a
href=\"$PHP_SELF?query=$query&page=$next_page&limit=$limit\">next</a>");}
?>
The problem i think is in the links, the $query
variable is whats messing its up
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
More information about the thelist
mailing list