page_limit = 1200; $sql->select = " * "; $sql->query_where = "where enable = 'Y' and (afaaexam_start is null or afaaexam_start < '". date("Y-m-d H:i:s")."') and (afaaexam_end is null or afaaexam_end > '". date("Y-m-d H:i:s")."') "; $sql->query_orderby = "ORDER BY orderby, afaaexam_serno desc"; $sql->orderby_method = "-1"; if (isset($_GET['page']) && is_numeric($_GET['page'])){ $page = $_GET['page']; } else { $page = 1; } $data_array = $sql->data($page); $page = $sql->page; $gdata = array(); foreach ( $data_array as $data ) { if ( ! isset( $gdata[ $data['afaaexam_type'] ] ) ) { $gdata[ $data['afaaexam_type'] ] = array(); } array_push( $gdata[ $data['afaaexam_type'] ], $data ); } $types = array_keys( $gdata ); ?>