[RESOLVED] pagination not working

[neizo]

Hello,
I use one of the pagination examples from the forum for my data. So the first page loads the data fine but when I click the next link nothing loads.

<?
			include("inc/connect.php");
			$page2 = $_GET['page2'];
			$limit = 5;
			$query_count = "SELECT * FROM proionta WHERE ID_CATEGORY = '$page2' ORDER BY TAX";
			$result_count = mysql_query($query_count);
			$totalrows = mysql_num_rows($result_count);

		$page = $_GET['page'];
		if(empty($page))
		$page = 1;
		$limitvalue = $page * $limit - ($limit);
		$query = "SELECT * FROM proionta WHERE ID_CATEGORY = '$page2' ORDER BY TAX LIMIT $limitvalue, $limit ";
		$result = mysql_query($query);
		$count_result = mysql_num_rows($result);
		while ($today = mysql_fetch_array($result)){
			echo ("<tr>
        <td width=\"29%\" height=\"100\" align=\"center\" valign=\"middle\" bgcolor=\"#B0C4E6\" class=\"maintext\">
		<a href=\"images-proionta/$today[5]\" rel=\"lightbox\"><img src=\"images-proionta/$today[4]\" width=\"120\" height=\"70\" border=\"0\" class=\"homeimages-border\"></a><br></td>
        <td width=\"71%\" height=\"100\" align=\"left\" valign=\"middle\" bgcolor=\"#B0C4E6\" class=\"maintext\">$today[3]</td>
      </tr>");
		}


		// Display links at the top to indicate current page and number of pages displayed
		$numofpages = ceil($totalrows / $limit);

		$from=$limit*$page-$limit+1;
		$to=$from + $count_result-1;

		// start 123 next>> table
		echo "<table align=\"center\" width=\"90%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">
					<tr><td width=\"50%\" bgcolor=\"$bg_colour\" align=\"left\">";if($numofpages>1){echo"Showing: $from - $to</td><td width=\"50%\" bgcolor=\"$bg_colour\" align=\"right\"><b>Go to page:</b> ";}

		// display previous link if page is not 1
		if($page != 1){
		$pageprev = $page - 1;
		echo("<a href=\"$PHP_SELF?page=$pageprev\"><< PREV</a>&nbsp;");
		}

		// display page nos if not 1
		for($i = 1; $i <= $numofpages; $i++){
		if($numofpages>1){
		if($i == $page)
		echo("&nbsp;".$i."&nbsp;");
		else
		echo("&nbsp;<a href=\"$PHP_SELF?page=$i\">$i</a>&nbsp;");
		}}

		// display next page link if there is more than one
		if(($totalrows - ($limit * $page)) > 0){
		$pagenext = $page + 1;
		echo("<a href=\"$PHP_SELF?page=$pagenext\">NEXT >></a>");
		}
		// end 123 next>> table
		echo"</td></tr></table><br>"; 			
		?>		  
      

[alimadzi]

Try echoing out $query on the page somewhere and running it directly in your database. The query looks like it would work. Are there more than 5 rows?

[neizo]

Try echoing out $query on the page somewhere and running it directly in your database. The query looks like it would work.

Yes the query works but when I click NEXT there is no data.😕

Are there more than 5 rows?

Yes, at the moment I have 10 records in my database.

[alimadzi]

Does the query that is echoed on the page after you click NEXT also work?

[neizo]

Look at the pictures (before click NEXT) and after.

[neizo]

I change this part.

echo("<a href=\"$PHP_SELF?page=$pagenext\">NEXT >></a>");

to this

echo("<a href=\"products-more.php?page=$pagenext\">NEXT >></a>");

but still not working.

[neizo]

I found the solution! God bless this forum!

echo("<a href=\"$PHP_SELF?page=$pageprev&page2=$page2\"><< PREV</a>&nbsp;");

must keep the value of variable "page2" to load the next page 😉 &page2=$page2,
now it is working fine 🙂

Thank you PHPBuilder for this amazing pagination script!

🆒

[alimadzi]

Umm, thanks? Did I miss something? Glad you got your issue resolved...