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
/
formsearch.php
diff --git
a/includes/formsearch.php
b/includes/formsearch.php
index ba1572a904bc4273ada71b5f8a49de9f1cc50fa1..6bd0fa1850372714c2224ecda11385873441e8fd 100644
(file)
--- 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="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();
@@
-73,7
+73,7
@@
if (empty($form_arrival_date)) {
<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();