[RESOLVED] Pagination Problem

[whobutsb]

So I followed this tutorial from PHPfreaks.com to set a pagination system for a page i'm doing. Everything is working good except when I click to skip ahead through the results they won't display. Is there something i'm missing?

<?php require_once('../../Connections/News.php'); 

$limit = 25;
$query_count = "SELECT * FROM news";
$result_count = mysql_query($query_count);
$totalrows= mysql_num_rows ($result_count);
// Check if $page variable is empty
if(empty($page)) {
	$page=1;
}

$limitvalue = $page * $limit - ($limit);

$query = "SELECT * FROM news LIMIT $limitvalue, $limit";
$result = mysql_query($query) or die (mysql_error());

if(mysql_num_rows($result) == 0) {
	echo "Nothing to Display!";
}

$bgcolor = "#E0E0E0"; ?>
<table>
	<?php
	while($row = mysql_fetch_array($result))
	{
		if($bgcolor == "#E0E0E0"){
			$bgcolor = "#FFFFFF";
		}else{
			$bgcolor = "#E0E0E0";
		}
		?>
<tr bgcolor = "<?php echo $bgcolor; ?>">
	<td><?php echo $row ['headline']; ?></td>
	<td>Body</td>
	<td><?php echo $row ['date']; ?></td>
	<? } ?>
</table>
<?php
// Next and Previous Links
 if($page != 1){  

        $pageprev = $page-1; 

    echo("<a href=\"".$_SERVER['PHP_SELF']."?page=$pageprev\">PREV</a> ");  
}else{ 
    echo("PREV".$limit." "); 
} 

$numofpages = $totalrows / $limit;  

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


if(($totalrows % $limit) != 0){ 
    if($i == $page){ 
        echo($i." "); 
    }else{ 
        echo("<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> "); 
    } 
} 

if(($totalrows - ($limit * $page)) > 0){ 
    $pagenext = $page+1; 

    echo("<a href=\"".$_SERVER['PHP_SELF']."?page=$pagenext\">NEXT ".$limit."</a>"); 
}else{ 
    echo("NEXT".$limit);  
} 

mysql_free_result($result); 

?> 

[cgraz]

when you grab $page from the url, you need to access it via $_GET['page'];

[whobutsb]

So should the Previous Button look somethign like this?

$pageprev = $_GET['page']-1;

[cgraz]

It might be less hassle to put this at the top of your script (before or after $limit perhaps)

$page = $_GET['page'];

Then just use $page from thereonafter.

[whobutsb]

Thank You Very Much!!! The $_GET['page'] corrected the problem. HAve a great day!