X-Git-Url: https://git.piment-noir.org/?p=Project_webapp.git;a=blobdiff_plain;f=includes%2Fformsearch.php;fp=includes%2Fformsearch.php;h=5cdca0cc4322af26d8bfe9402bc0d26a009aa11f;hp=cd12ee4a5b988b8aff76f592022ed64c1f77cd3e;hb=181c3ee47dbbd650216b0e39d6539dc2c6d2b811;hpb=68cee0ac3fe728566e16dc0460416c77022f4b22

diff --git a/includes/formsearch.php b/includes/formsearch.php
index cd12ee4..5cdca0c 100644
--- a/includes/formsearch.php
+++ b/includes/formsearch.php
@@ -132,7 +132,7 @@ if (!$input_failure) {
          echo "    <th>Re&#769;server</th>\n";
          echo "  </tr>\n";
          foreach ($fligths as $fligth) {
-             $sql_pquery = "select sum(NbPlaces) from RESERVATIONS where NumVol = ?";
+             $sql_pquery = "select sum(NbPlaces) as BookedPlaces from RESERVATIONS where NumVol = ?";
              $connection->prepare_query($sql_pquery);
              $connection->prepared_query_bind_param("s", array($fligth['NumVol']));
              $connection->run_prepared_query();
@@ -157,7 +157,7 @@ if (!$input_failure) {
              echo "    <td>" . $fligth['Classe'] . "</td>\n";
              echo "    <td>" . $fligth['Prix'] . "&euro;</td>\n";
              echo "    <td>
-                        Places libres : " . $free_places . "
+                        Nombre de places libres : " . $free_places . "
                         <form action=\"index.php\" id=\"booking\" method=\"post\">
                           <input type=\"hidden\" name=\"form\" value=\"booking\" />
                           <input type=\"hidden\" name=\"flight_id\" value=\"" . $fligth['NumVol'] . "\" />