"; } print $text; ?>

---

Events

$topic

---

"; } $result = mysqli_query($conn, $query) or die('Error, query failed'); $numrows = mysqli_num_rows($result); // how many pages we have when using paging? $maxPage = ceil($numrows/$rowsPerPage); $self = $_SERVER['PHP_SELF']; // creating 'previous' and 'next' link // plus 'first page' and 'last page' link // print 'previous' link only if we're not // on page one if ($pageNum > 1) { $page = $pageNum - 1; $prev = " [Prev] "; $first = " [First Page] "; } else { //$prev = ' [Prev] '; // we're on page one, don't enable 'previous' link //$first = ' [First Page] '; // nor 'first page' link } // print 'next' link only if we're not // on the last page if ($pageNum < $maxPage) { $page = $pageNum + 1; $next = " [Next] "; $last = " [Last Page] "; } else { //$next = ' [Next] '; // we're on the last page, don't enable 'next' link //$last = ' [Last Page] '; // nor 'last page' link } // print the page navigation link echo $first . $prev . " Showing page $pageNum of $maxPage pages " . $next . $last; if ($maxPage == 0) { print "

Oh! no lesson available"; } ?>