<select size="1" name="departure_city" required>
<optgroup label="Sélectionner une ville">
<?php
- $sql_pquery = "select distinct VilleD from VOLS";
+ $sql_pquery = "select distinct VilleD from VOLS order by VilleD";
global $connection;
$connection->prepare_query($sql_pquery);
$connection->run_prepared_query();
<select size="1" name="arrival_city" required>
<optgroup label="Sélectionner une ville">
<?php
- $sql_pquery = "select distinct VilleA from VOLS";
+ $sql_pquery = "select distinct VilleA from VOLS order by VilleA";
global $connection;
$connection->prepare_query($sql_pquery);
$connection->run_prepared_query();