prefix . "abTimeSlotMst"; $abSlotMappingDetails = $wpdb->prefix . "abSlotMappingDetails"; $getWorkingDayResult = $wpdb->get_results("SELECT slotId, slotName, slotStartTime, slotEndTime, maxAppointmentsPerSlot FROM ".$abTimeSlotMst." WHERE isDeleted=0", ARRAY_A); if(!$getWorkingDayResult) { //if-1 ?>
YOU NEED TO SELECT WORKING HOUR'S SLOTS / TIME SLOTS FIRST.
get_results("Select slotId,slotName,DATE_FORMAT(slotStartTime, '%H:%i') as slotStartTime,DATE_FORMAT(slotEndTime, '%H:%i') as slotEndTime,maxAppointmentsPerSlot from ".$abTimeSlotMst ." where isDeleted=0",ARRAY_A); $slotList=$wpdb->get_results("Select slotId from ".$abTimeSlotMst." where isDeleted=0",ARRAY_A); ?>
get_results("Select workingDay,slotId,isDeleted from ".$abSlotMappingDetails." where isDeleted=0 And slotId=".$result['slotId'],ARRAY_A); ?>
Slot Name Time Slot Working Days
" data-id="" />