X-Git-Url: https://git.piment-noir.org/?p=Project_webapp.git;a=blobdiff_plain;f=includes%2Fformsearch.php;h=6bd0fa1850372714c2224ecda11385873441e8fd;hp=ba1572a904bc4273ada71b5f8a49de9f1cc50fa1;hb=f38123a5d3eafd9af6fb25e1dd5ccf29c5508b36;hpb=8d17cae35f4eb54914596e544f4a6ee43268426d

diff --git a/includes/formsearch.php b/includes/formsearch.php
index ba1572a..6bd0fa1 100644
--- a/includes/formsearch.php
+++ b/includes/formsearch.php
@@ -50,7 +50,7 @@ if (empty($form_arrival_date)) {
  <select size="1" name="departure_city" required>
   <optgroup label="Se&#769;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();
@@ -73,7 +73,7 @@ if (empty($form_arrival_date)) {
  <select size="1" name="arrival_city" required>
   <optgroup label="Se&#769;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();