1. Get data from database:

   $this->db->select('journey_id, air_id, FlightDuration, out_or_in, flightduration2'); $this->db->from('your_table_name'); // Replace 'your_table_name' with the actual table name $query = $this->db->get(); $data = $query->result_array();

2. Create an empty array to save grouped data:

   $grouped_data = array();

3. Iterate over the acquired data and group it by air_id:

   foreach ($data as $row) { $air_id = $row['air_id']; // Check if the air_id already exists in the grouped_data array if (!isset($grouped_data[$air_id])) { // If not, initialize an empty array for this air_id $grouped_data[$air_id] = array(); } // Add the current row to the group for this air_id $grouped_data[$air_id][] = $row; }

4. Now you have the data grouped by air_id in the $grouped_data array. You can iterate through this array to display the data you specify:

   foreach ($grouped_data as $air_id => $group) { echo "air_id - $air_id
   "; foreach ($group as $row) { echo $row['FlightDuration'] . ' ' . $row['out_or_in'] . ' ' . $row['flightduration2'] . '
   '; } echo "
   "; }

This code will loop through the grouped data and display it as you describe, each group of flight data is under the corresponding air_id.