Next / Previous Links not Working

[smatts9]

<?
include('includes/db.php');
if(!$rowstart) $rowstart=0;
$result = "select * from users limit $rowstart,5";
$result2 = mysql_query("select * from users");
$numrows = mysql_num_rows($result2);
 $results = mysql_query( $result );
 if( $results )
 {
 while( $users = mysql_fetch_object( $results ) )
 {
  $username = $users -> username;
   echo( "$username<br />" );
 }
 }
 else
 {
 die( "Trouble getting contacts from database: " . mysql_error() );
 }
if ($rowstart!= 0) { 
  echo '<a href="'.$_SERVER['PHP_SELF'].'?rowstart='.($rowstart - 5).'">&lt; Previous Page</a>';
 }
 if (($rowstart!= 0) && (($rowstart + 5) < $numrows)) echo ' ¦ ';
 if (($rowstart + 5) < $numrows) {
  echo '<a href="'.$_SERVER['PHP_SELF'].'?rowstart='.($rowstart + 5).'">Next Page &gt;</a>';
 }
?>

I have more than 5 entries and when I click the 'Next' Link it just stays at the first 5 results?... I am stuck on this one.

[dreamcatcher]

Hi smatts9,

It may be a register globals issue.

Try changing this line:

if(!$rowstart) $rowstart=0;

to this:

$rowstart = (isset($_GET['rowstart'])? $_GET['rowstart'] : '0');

dc