Something like
$page = $_GET[“page”];
$start = 5 + 50 * ($page - 1);
$rows = 50;
$sql = “SELECT … FROM table WHERE … LIMIT $start, $rows”;
adminview
<ul>
<li><a href="page.php?page=1">Page 1</li>
<li><a href="page.php?page=2">Page 2</li>
</ul>