prefix .'abHolidayMst'; $total_query_holiday = "SELECT COUNT(*) FROM ".$wp_abHolidayMst." WHERE isDeleted=0"; $total_holiday = $wpdb->get_var( $total_query_holiday ); $items_per_page_holiday = 5; $page_holiday = isset( $_GET['paged'] ) ? abs( (int) $_GET['paged'] ) : 1; $offset_holiday = ( $page_holiday * $items_per_page_holiday ) - $items_per_page_holiday; $holidayResult = $wpdb->get_results( "SELECT holidayId, holidayName, holidayDate FROM ".$wp_abHolidayMst." WHERE isDeleted=0 ORDER BY holidayId DESC LIMIT ".$offset_holiday.", ".$items_per_page_holiday."", ARRAY_A ); $totalHolidayPage = ceil($total_holiday / $items_per_page_holiday); foreach($holidayResult as $trRes){ ?>

Holiday Name	Holiday Date	Edit	Delete
		Edit	Delete