diff options
Diffstat (limited to 'beta_old1/app/index.php')
| -rw-r--r-- | beta_old1/app/index.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/beta_old1/app/index.php b/beta_old1/app/index.php index eefb768..572c656 100644 --- a/beta_old1/app/index.php +++ b/beta_old1/app/index.php @@ -92,7 +92,7 @@ generate_html_div_help(); // Réunions fixées et passées $query = 'SELECT DISTINCT R.idR, R.objetR, P.nomP, P.prenomP, UNIX_TIMESTAMP(C.dateHeure), R.estAnnulee' - . ' FROM Liste L,Reunion R,Appartenir A,Creneau C,Personne P' + . ' FROM AWOR_Liste L,AWOR_Reunion R,AWOR_Appartenir A,AWOR_Creneau C,AWOR_Personne P' . " WHERE ((A.idP = $idP AND A.idL = L.idL) OR R.idP_Orga = $idP)" . ' AND R.idL = L.idL AND P.idP = R.idP_Orga AND R.idC_Fixe = C.idC' . ' ORDER BY C.dateHeure DESC;'; @@ -100,7 +100,7 @@ generate_html_div_help(); // Réunion en préparation $query = 'SELECT DISTINCT R.idR, R.objetR, P.nomP, P.prenomP, NULL, R.estAnnulee' - . ' FROM Liste L,Reunion R,Appartenir A,Personne P' // Creneau C, + . ' FROM AWOR_Liste L,AWOR_Reunion R,AWOR_Appartenir A,AWOR_Personne P' // Creneau C, . " WHERE ((A.idP = $idP AND A.idL = L.idL) OR R.idP_Orga = $idP)" . ' AND R.idL = L.idL AND P.idP = R.idP_Orga AND ISNULL(R.idC_Fixe);'; //echo "DEBUG : $query\n"; |