X-Git-Url: https://git.piment-noir.org/?a=blobdiff_plain;f=includes%2Fsearch.php;h=6ae2621888f0b1e2d0252df0b85446746aa63de8;hb=HEAD;hp=e2503d96536f5e1988e5a485cf3b77d09ef5595d;hpb=77c2d82c70ae6b1629d372b3c4642cdc2a994698;p=Project_webapp.git

diff --git a/includes/search.php b/includes/search.php
index e2503d9..6ae2621 100644
--- a/includes/search.php
+++ b/includes/search.php
@@ -28,7 +28,7 @@ if ($action === "return_flight") {
  <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();
@@ -51,7 +51,7 @@ if ($action === "return_flight") {
  <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();