X-Git-Url: https://git.piment-noir.org/?p=Project_webapp.git;a=blobdiff_plain;f=includes%2Freservations.php;h=0d32077720b46e5c5271580c0ad8461c44a3833b;hp=0416bd5af660a159d5777a2029ebf2723021282a;hb=68cee0ac3fe728566e16dc0460416c77022f4b22;hpb=a0e7c679474abba8e61aa6241f7a5293ab631cc1

diff --git a/includes/reservations.php b/includes/reservations.php
index 0416bd5..0d32077 100644
--- a/includes/reservations.php
+++ b/includes/reservations.php
@@ -17,7 +17,7 @@ $oDateNow = new Datetime($date_now);
 global $connection;
 $sql_pquery = "select RESERVATIONS.NumVol as NumVol, VilleD, DateD, VilleA, DateA, RESERVATIONS.Classe, NbPlaces, round(CoutVol*CoeffPrix*NbPlaces, 2) as Prix
                from RESERVATIONS join VOLS on RESERVATIONS.NumVol = VOLS.NumVol
-               join DEFCLASSES on DEFCLASSES.NumVol = VOLS.NumVol and RESERVATIONS.Classe = DEFCLASSES.Classe
+               join DEFCLASSES on DEFCLASSES.NumVol = RESERVATIONS.NumVol and DEFCLASSES.NumVol = VOLS.NumVol and DEFCLASSES.Classe = RESERVATIONS.Classe
        		   where NumCl = ? and DateD > ?
                order by DateD, NumVol, Prix";
 $connection->prepare_query($sql_pquery);