$perpage = 9; $page = (int) $_GET['page']; $start = $page * $perpage; SELECT * FROM gallery WHERE MONTH(date_added) = $month AND status = '1' ORDER BY date_added DESC LIMIT $start, $perpage