<?php
                                  // perform database query
                                  $query = "SELECT id, municipality FROM airports";

                                  $result = mysqli_query($connection, $query);

                                  if(!$result){
                                      die("Database query failed.");
                                  }// only for syntax errors
                                  // Select query for arrival
                                  echo "<select name='arrival'>";
                                  while($row = mysqli_fetch_assoc($result)){
                                   unset($id, $name);
                                        $id = $row['id'];
                                        $name = $row['municipality'];
                                        echo '<option value="'.$name.'">'.$name.'</option>';
                                  }
                                  echo "</select>";
                                   // release returned data
                                  mysqli_free_result($result);
                              ?>