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
ANY NEED HELP AS THIS IS ONLY THING MESSING UP, PLEASE
