Help

[Evilace]

i could use some help really, basically i have a page that displays reports, i have added page numbers to split the results to multiple pages, eveything is ok however when i delete a report/log which is another script that deletes it, all that works however it does not update the page numbers properly once you have deleted all the reports on that page, so say you have one page that is empty and one that has reports in, but the other still shows instead of just saying page 1 of 1, it still lets you view all the other pages that were recorded but display blank, ie Showing page 1 of 5 pages [Next] [Last Page]

 

here is the page script in the file

 

$rowsPerPage = 10;

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

  $offset = ($pageNum - 1) * $rowsPerPage;
  
  $res = $db->query("SELECT * FROM ".$gameid."_battlereports WHERE attacked='$playerid' OR attacker='$playerid' ORDER BY id DESC LIMIT $offset, $rowsPerPage"); 
  $count = $db->query("SELECT COUNT(id) AS numrows FROM ".$gameid."_battlereports WHERE attacked='$playerid' OR attacker='$playerid'");
  $row = mysql_fetch_assoc($count);
  $numrows = $row['numrows'];
			  
  $maxPage = ceil($numrows/$rowsPerPage);

  $self = $_SERVER['PHP_SELF'];
  $nav  = '';
  
  for($page = 1; $page <= $maxPage; $page++)
{
   if ($page == $pageNum)
   {
      $nav .= " $page ";
   }
   else
   {
      $nav .= " <a href='$self?act=$brpt_a&game=t&page=$page'>$page</a> ";
   } 
}

if ($pageNum > 1)
{
   $page  = $pageNum - 1 ;
   $prev  = " <a href='$self?act=$brpt_a&game=t&page=$page'>[Prev]</a> ";

   $first = " <a href='$self?act=$brpt_a&game=t&page=1'>[First Page]</a> ";
} 
else
{
   $prev  = ' ';
   $first = ' ';
}

if ($pageNum < $maxPage)
{
   $page = $pageNum + 1;
   $next = " <a href='$self?act=$brpt_a&game=t&page=$page'>[Next]</a> ";

   $last = " <a href='$self?act=$brpt_a&game=t&page=$maxPage'>[Last Page]</a> ";
} 
else
{
   $next = ' ';
   $last = ' ';
}

// Output goes here so much im not posting it

echo "<center><br />".$first."".$prev." Showing page ".$pageNum." of ".$maxPage." pages ".$next."".$last."</center>";

 

if you need any more info please say, any help appretitated

[Evilace]

any ideas? this has been bugging me for ages, i just dont understand why its not updating the page number when you delete a report, it works ok apart from that