prefix . "abTimeSlotMst"; $abSlotMappingDetails = $wpdb->prefix . "abSlotMappingDetails"; $getWorkingDayResult = $wpdb->get_results("SELECT slotId, slotName, slotStartTime, slotEndTime, maxAppointmentsPerSlot FROM ".$abTimeSlotMst." WHERE isDeleted=0", ARRAY_A); /*echo "
";
print_r($getWorkingDayResult);
exit;*/
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);
//$countSlots = $wpdb->num_rows();

$slotList=$wpdb->get_results("Select slotId from ".$abTimeSlotMst." where isDeleted=0",ARRAY_A);
/*echo "
";
print_r($fetchWorkingDays);
echo "
";*/
?>



    

    	

            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=""  />