repositories
/
Project_webapp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Fix the SQL for reservations class modification.
[Project_webapp.git]
/
includes
/
search.php
diff --git
a/includes/search.php
b/includes/search.php
index e2503d96536f5e1988e5a485cf3b77d09ef5595d..6ae2621888f0b1e2d0252df0b85446746aa63de8 100644
(file)
--- 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="Sélectionner une ville">
<?php
<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();
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="Sélectionner une ville">
<?php
<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();
global $connection;
$connection->prepare_query($sql_pquery);
$connection->run_prepared_query();