[Resolved] << Previous link in pagination not working..

phence

My previous link, instead of going to the previous page of results, it always goes to the very first page of results each time. I can't seem to find out why it's not working right... it looks like it should to me. Please inlighten if you can! Thanks!

<?php
	// If current page number, use it 
	// if not, set one! 

if(!isset($_GET['page'])){ 
	$page = 1; 
} else { 
	$page = $_GET['page']; 
} 

// Define the number of results per page 
$max_results = 1; 

// Figure out the limit for the query based 
// on the current page number. 
$from = (($page * $max_results) - $max_results); 

// Perform MySQL query on only the current page number's results 
$sql = mysql_query("SELECT * FROM table WHERE MATCH (variable) 
AGAINST ('$searchValue') ORDER BY (yep) ASC LIMIT $from, $max_results"); 

if (mysql_num_rows($sql) <= 0){
	echo "sorry no results were found";
}elseif (mysql_num_rows($sql) > 0){
	// Create Table and Table Headings // HTML cut out for thread length
	while($row = mysql_fetch_array($sql)){ 	
		// Display // Alternate $color, for differ colored rows
		if($bgcolor=='#DFDFDF'){ $bgcolor='#EFEFEF'; } else { $bgcolor='#DFDFDF'; } 
		// HTML cut out for thread length
	} // End While
	// End Table & other <HTML>

	// Figure out the total number of results in DB: 
	$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM table 
	WHERE MATCH (variable) AGAINST ('$searchValue')"),0); 

	// Figure out the total number of pages. Always round up using ceil() 
	$total_pages = ceil($total_results / $max_results); 

	// Build Page Number Hyperlinks 
	// Build Previous Link  *** NOT WORKING *** --> Goes back to first page.. not Previous page ??
	if($page > 1){ 
		$prev = ($page - 1); 
		echo "<a href=\"".$_SERVER['PHP_SELF'].
		"?page=$prev&searchValue=$searchValue\"><<Previous</a>&nbsp;"; 
	} 

	for($i = 1; $i <= $total_pages; $i++){ 
		if(($page) == $i){ 
    		echo "$i&nbsp;"; 
    	} else { 
       		echo "<a href=\"".$_SERVER['PHP_SELF'].
			"?page=$i&searchValue=$searchValue\">$i</a>&nbsp;"; 
		} 
	} 

	// Build Next Link 
	if($page < $total_pages){ 
		$next = ($page + 1); 
		echo "<a href=\"".$_SERVER['PHP_SELF']."
		?page=$next&searchValue=$searchValue\">Next>></a>"; 
	} 
} // end else if
?>

Hope you can help! It will turn out to be a really nice Pagination script if it gets fixed!(i think i found it in on of the threads anyway) Thank-you!

phence

I still cannot figure this out.. anyone have any ideas or seggestions?

TheDefender

I know this is going to sound silly, but it is something I stumbled onto while coding something just today, as a matter of fact, and it drove me nuts.

if($page > 1){  

            $prev = ($page - 1);  

            echo "<a href=\"".$_SERVER['PHP_SELF']. 
            "?page=$prev&searchValue=$searchValue\"><<Previous</a>&nbsp;";  

        }

Where you have your $_SERVER['PHP_SELF'] variable, try putting the page name. (Just to test it out) so change it to:

if($page > 1){  

            $prev = ($page - 1);  

            echo "<a href=\"whatever.php?page=$prev&searchValue=$searchValue\"><<Previous</a>&nbsp;";  

        }

This is really to test things out and get the help ball rolling here. I was working on something and my variable kept hanging around (for a reason I am trying to find) when I was trying to use the variable like you, but when I hard coded the page's name, it worked. Let's rule that in or out first.

Secondly, try echoing your $prev and $page values, to see what they are showing as... If your $prev variables equals 1, then you know why it's going back to page 1, and then we need to start looking at why it is valued at 1.

TheDefender

if($page > 1){   

            $prev = ($page - 1);   

            echo "<a href=\"".$_SERVER['PHP_SELF'].  

            "?page=$prev&searchValue=$searchValue\"><<Previous</a>&nbsp;";   

        }

Oh, one other thing to note... In my pagination script I wrote, I didn't define a $prev variable. Instead, I just place the calculation directly into my anchor tag like so:

if($page > 1){
  echo "<a href=\"".$_SERVER['PHP_SELF']."?page=".($page - 1)."&searchValue=$searchValue\"><<Previous</a>&nbsp;";   

}

Just something else to look at.

phence

Well after trying the things you seggested i figured out the problem!

And it would have been easily solved if i even posted the right script!! I accidently posted a secondary script, instead of the script that was giving me problems!

and i found that when ever i had copied the secondary script it wasn't the same script that had the problem...

BUT! In the script with the problem i had...

if($page > 1){    

            $prev = ($page - 1);    

            echo "<a href=\"".$_SERVER['PHP_SELF'].   

            "?[B]$[/B]page=$prev&searchValue=$searchValue\"><<Previous</a>&nbsp;";    

        }

For some reason i had a "$" infront of the page variable!!!

but now everything is working!! Thanks!

TheDefender

Yeah, that would do it too ;-)

Sometimes, even posting the wrong snippet in the first place helps, because it got you looking into and scrutinizing your failing code... Sorry I couldn't be more of a help to you. Best wishes.