// 1. the current page number ($current_page) $page = !empty($_GET['page']) ? (int) $_GET['page'] : 1; // 2. records per page ($per_page) $per_page = 3; // 3. total record count ($total_count) $total_count = Main_pictures::count_all(); // Find all photos // use pagination instead //$photos = Photograph::find_all(); $pagination = new Pagination($page, $per_page, $total_count); // Instead of finding all records, just find the records // for this page $sql = "SELECT * FROM main_pictures ORDER BY comid DESC "; $sql .= "LIMIT {$per_page} "; $sql .= "OFFSET {$pagination->offset()}"; $photos = Main_pictures::find_by_sql($sql); // Need to add ?page=$page to all links we want to // maintain the current page (or store $page in $session) ?> <!--End Pagination --> <div id="content_left"> <div id="pic_and_news"> <?php foreach ($photos as $photo) { ?> <h2><?php