diff options
Diffstat (limited to 'beta_old1/app/poppersonne.php')
| -rw-r--r-- | beta_old1/app/poppersonne.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/beta_old1/app/poppersonne.php b/beta_old1/app/poppersonne.php index 3335c6b..e9225ba 100644 --- a/beta_old1/app/poppersonne.php +++ b/beta_old1/app/poppersonne.php @@ -24,8 +24,8 @@ if (!isset($_GET['idL'])) else { echo "dataListe('participants','dataParticipants'));\">"; - if (isset($_GET['idR'])) $req = "SELECT * FROM Liste L,Reunion R WHERE (L.idP_Createur=".$_GET['idP_orga']." OR R.idP_Orga=".$_GET['idP_orga'].") AND R.idL=L.idL"; - else $req = "SELECT * FROM Liste L,Reunion R WHERE L.idL=".$_GET['idL']." AND L.idP_Createur=".$_GET['idP_orga']; + if (isset($_GET['idR'])) $req = "SELECT * FROM AWOR_Liste L,AWOR_Reunion R WHERE (L.idP_Createur=".$_GET['idP_orga']." OR R.idP_Orga=".$_GET['idP_orga'].") AND R.idL=L.idL"; + else $req = "SELECT * FROM AWOR_Liste L,AWOR_Reunion R WHERE L.idL=".$_GET['idL']." AND L.idP_Createur=".$_GET['idP_orga']; $result = mysql_query($req); if (mysql_num_rows($result)>0) { @@ -46,7 +46,7 @@ else <option value="None">Choisir ...</option> <option value="Tous">Tous</option> <?php - $req = "SELECT idL,libelleL,estPrivee FROM Liste WHERE (idP_Createur=".$_GET['idP_orga']." OR estPrivee='non')"; + $req = "SELECT idL,libelleL,estPrivee FROM AWOR_Liste WHERE (idP_Createur=".$_GET['idP_orga']." OR estPrivee='non')"; if (isset($_GET['idL'])) $req .= " AND idL <>".$_GET['idL']; $req .= " ORDER BY estPrivee"; $result = mysql_query($req); @@ -83,7 +83,7 @@ else <?php if (isset($_GET['idL'])) { - $req = "SELECT P.idP,P.courrielP,P.nomP,P.prenomP FROM Personne P,Appartenir A WHERE P.idP=A.idP AND A.idL=".$_GET['idL']; + $req = "SELECT P.idP,P.courrielP,P.nomP,P.prenomP FROM AWOR_Personne P,AWOR_Appartenir A WHERE P.idP=A.idP AND A.idL=".$_GET['idL']; $result = mysql_query($req); if (mysql_num_rows($result)>0) { |