Have fun with PHP arrays and date functions -- 2

Task is in comments - only $is_specific_date =='1' and $is_weekend =='1' need work. if ($is_specific_date =='1') { // Push $start and $end into $dates_array[] as outbound ($start) and inbound ($end) } else if ($is_holiday =='1') { $sql = "SELECT country FROM `airport` WHERE iata = '$fromCode'"; var_dump($sql); $country = $con->query($sql); $row = $country->fetch_assoc(); $country = $row['country']; $sql = "SELECT (date - INTERVAL 1 DAY) AS outbound, (date + INTERVAL 2 DAY) AS inbound FROM `holidays` WHERE date> NOW() and date < (NOW() + INTERVAL 1 YEAR) and country like '$country' "; var_dump($sql); $dates = $con->query($sql); $dates_array[] = $row; while( $row = mysqli_fetch_array($dates)){ $dates_array[$row['outbound']]['outbound'] = $row['outbound']; $dates_array[$row['outbound']]['inbound'] = $row['inbound']; } var_dump($dates_array); } else if ($is_weekend =='1') { echo $start; echo $end; echo $startw; echo $endw; /* Find all Thursdays and Sundays in between start and end. If start is less than today's date use today's date instead. Save into array with Thursday as Outbound and Sunday as Inbound (see above) */ }