php paging

PHP kode 

 <?
   $sql = "SELECT COUNT(*) FROM news";
   $result2 = mysqli_query($connection, $sql);
   $row = mysqli_fetch_row($result2);
   $numrows = $r[0];
 
   $rowsperpage = 10;
   $totalpages = ceil($numrows / $rowsperpage);
 
   if (isset($_GET['page']) && is_numeric($_GET['page'])) {
        $currentpage = (int) $_GET['page'];
     } else {
        $currentpage = 1;
     }
 
     if ($currentpage > $totalpages) {
        $currentpage = $totalpages;
     }
 
     if ($currentpage < 1) {
        $currentpage = 1;
     }
     
     $offset = ($currentpage - 1) * $rowsperpage;
 ?>
 
 <?
     $sql = "SELECT * FROM news ORDER BY newsid DESC LIMIT $offset, $rowsperpage";
     $result = mysqli_query($connection, $sql);
     $rows = array();
     while ($row = mysqli_fetch_assoc($result)) {
         $rows[] = $row;
     }
         foreach($rows as $row) {
 ....

PHP kode 

 if ($currentpage != $totalpages) {
       $nextpage = $currentpage + 1;
         echo "<a href='?page_no=".$nextpage."'>Next</a>&nbsp;&nbsp;";