Online PHP editor | refs for ucYP2

<?php $array = [ 0 => [ "room_id" => "1", "date" => "01-07-2022", "available" => "A" ], 1 => [ "room_id" => "2", "date" => "01-07-2022", "available" => "A" ], 2 => [ "room_id" => "1", "date" => "02-07-2022", "available" => "A" ], 3 => [ "room_id" => "2", "date" => "02-07-2022", "available" => "U" ], 4 => [ "room_id" => "1", "date" => "03-07-2022", "available" => "U" ], 5 => [ "room_id" => "2", "date" => "03-07-2022", "available" => "U" ], 6 => [ "room_id" => "1", "date" => "04-07-2022", "available" => "U" ], ]; $hasVacancy = []; $result = []; foreach ($array as $row) { if ($row['available'] === 'A') { $hasVacancy[$row['date']] = $row; // store available as reference unset($result[$row['date']]); // remove potentially stored unavailable row for date } elseif (!isset($hasVacancy[$row['date']])) { $result[$row['date']] = $row; // is unavailable and no availables found } } var_export(array_values($result));