PHP - Pagnation Problem

Hello All,

I followed the very good tutorial from this site to allow me to paginate my pages.
I have managed to get it working but not as I imagined so I think something is slightly wrong with my interperation.

I have the number of items to show set to 15. If the number of items retrned is 16 i expected the first page to display the first 15 rows and the second page to display the last and only single row. At the moment it displays the first 15 on page 1 and the last 15 on page 2.
Is this how it should work or have I coded incorrectly.

Code: [Select]
$sql = "SELECT COUNT(*) FROM members";

$result = mssql_query( $sql, $conn )
or die( "Err: EXE" );

$r = mssql_fetch_row($result);
$numrows = $r[0];

// number of rows to show per page
$rowsperpage = 15;
// find out total pages
$totalpages = ceil($numrows / $rowsperpage);

// get the current page or set a default
if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage']))
{   
// cast var as int   
$currentpage = (int) $_GET['currentpage'];
}
else
{   
// default page num   
$currentpage = 1;
} // end if

// if current page is greater than total pages...
if ($currentpage > $totalpages)
{ 
// set current page to last page   
$currentpage = $totalpages;
} // end if
// if current page is less than first page...
if ($currentpage < 1)
{   
// set current page to first page   
$currentpage = 1;
} // end if

// the offset of the list, based on current page
$offset = ($currentpage) * $rowsperpage;

/******  build the pagination links (repeated below so displayed top and bottom of page)******/
$range = 3;

// if not on page 1, don't show back links
if ($currentpage > 1)
{   
// show << link to go back to page 1   
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<[First]</a> ";   
// get previous page num   
$prevpage = $currentpage - 1;   
// show < link to go back to 1 page   
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><[Prev]</a> ";
} // end if

// loop to show links to range of pages around current page
for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++)
{ 
// if it's a valid page number... 
  if (($x > 0) && ($x <= $totalpages))
    {     
    // if we're on current page...     
if ($x == $currentpage)
{         
// 'highlight' it but don't make a link       
echo " [<b>$x</b>] ";     
// if not current page...     
}
else
{       
  // make it a link         
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";     
  } // end else   
  } // end if
} // end for                 
   
   // if not on last page, show forward and last page links       
   if ($currentpage != $totalpages) { 
    // get next page 
$nextpage = $currentpage + 1;   
// echo forward link for next page   
  echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>[Next]></a> ";   
  // echo forward link for lastpage   
  echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>[Last]>></a> ";
  } // end if
  /****** end build pagination links ******/
 
// get the info from the db
$sqlnum = "SELECT * FROM (
SELECT TOP $rowsperpage * FROM (
SELECT TOP $offset * FROM members order by member_id ASC)
AS newtbl ORDER BY member_id DESC )
AS newtbl2 ORDER BY member_id ASC";
$result = mssql_query( $sqlnum, $conn )
or die( "ERR: EXE" );

$num = mssql_num_rows ($result);
if ($num !=0)
{
while ($row = mssql_fetch_assoc($result))
{
$student_name = rtrim($row["forename"])." ".rtrim($row["surname"]);
$member_id = $row["member_id"];
$profile = nl2br($row["profile"]);
$list .= "<tr>";
$list .= "<th class=table colspan=2>".$member_name." (".$memebr_id.")</th>";
$list .= "</tr><tr>";
if ($row["profile"] == NULL)
{
$list .= "<td class=table><font color=\"red\">A profile has not been saved for this member</font></td>";
}
else
{
$list .= "<td class=tblleft>$profile</td>";
}
$list .= "<td class=table><form action=\"personal_details.php\" method=\"post\"><input type=\"hidden\" name=\"member_id\" value=\"$member_id\"><input type=\"submit\" value=\"View Detail\" class=\"submit\"></form></td>";
$list .= "</tr><tr>";
}
$list .= "</table>";

echo( $list );

/******  build the pagination links ******/
// if not on page 1, don't show back links
if ($currentpage > 1)
{   
// show << link to go back to page 1   
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<[First]</a> ";   
// get previous page num   
$prevpage = $currentpage - 1;   
// show < link to go back to 1 page   
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><[Prev]</a> ";
} // end if

// loop to show links to range of pages around current page
for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++)
{ 
// if it's a valid page number... 
  if (($x > 0) && ($x <= $totalpages))
    {     
    // if we're on current page...     
if ($x == $currentpage)
{         
// 'highlight' it but don't make a link       
echo " [<b>$x</b>] ";     
// if not current page...     
}
else
{       
  // make it a link         
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";     
  } // end else   
  } // end if
} // end for                 
   
   // if not on last page, show forward and last page links       
   if ($currentpage != $totalpages) { 
    // get next page 
$nextpage = $currentpage + 1;   
// echo forward link for next page   
  echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>[Next]></a> ";   
  // echo forward link for lastpage   
  echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>[Last]>></a> ";
  } // end if
  /****** end build pagination links ******/
}
else
{
echo ("You do not have any Members");
}
Many Thanks