+ <select size="1" name="departure_city" required>
+ <optgroup label="Sélectionner une ville">
+ <?php
+ $sql_pquery = "select distinct VilleD from VOLS";
+ global $connection;
+ $connection->prepare_query($sql_pquery);
+ $connection->run_prepared_query();
+ $connection->get_pquery_result();
+ $cities = $connection->get_result_array();
+ $connection->close_prepared_query();
+ foreach ($cities as $city) {
+ if (strcmp($city[0], $return_flight_departure_city) === 0) {
+ echo "<option value=\"$city[0]\" selected>$city[0]</option>\n";
+ } else {
+ echo "<option value=\"$city[0]\">$city[0]</option>\n";
+ }
+ }
+ ?>
+ </optgroup>
+ </select>