find_array(); $total_pages = count($get_posts_tbl); /* Setup vars for query. */ $targetpage = "pagination.php"; //your file name (the name of this file) $limit = 10; //how many items to show per page $page = $_GET['page']; if($page) $start = ($page - 1) * $limit; //first item to display on this page else $start = 0; //if no page var is given, set start to 0 /* Get data. */ $result = $db->prepare("SELECT * FROM news ORDER BY id DESC LIMIT $start, $limit"); $result->execute(); /* Setup page vars for display. */ if ($page == 0) $page = 1; //if no page var is given, default to 1. $prev = $page - 1; //previous page is page - 1 $next = $page + 1; //next page is page + 1 $lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up. $lpm1 = $lastpage - 1; //last page minus 1 ?> Showing of

#	Title	Date	Action

fetch(); $i++){ ?>

			View Edit Delete