<?php

    include("connexion.php");
    $idEtablissement=isset($_POST['idEtablissement'])?$_POST['idEtablissement']:"";
    $req="SELECT distinct(mail)  FROM Etudiant, Etablissement WHERE  mail<> ' '  and nature='1'  ";

    $result= mysql_query($req);
    if ($result === false) {
        echo 'Erreur SQL ! ' . $req . '<br/>' . mysql_error();
    } else {
        echo "Les mails des étudiants des universités : "."<br/><br/>";
       while($ligne = mysql_fetch_assoc($result)){

          
         
         
        echo "<br/>".$ligne['mail']."<br/>";
       
       
          
      
        }
        mysql_free_result($result);
    }

?>
 

$req="SELECT distinct(mail)  FROM Etudiant, Etablissement WHERE Etudiant.idEtablissement=Etablissement.idEtablissement and  mail<> ' '  and nature='1'  ";

$req="SELECT distinct(Etudiant.mail)  FROM Etudiant, Etablissement WHERE Etudiant.idEtablissement=Etablissement.idEtablissement and Etudiant.mail<> ' ' and Etablissement.nature='1'  ";

$req="SELECT distinct(Etudiant.mail)  FROM Etudiant, Etablissement WHERE Etudiant.idEtablissement=Etablissement.idEtablissement and Etudiant.mail<> ' ' and Etablissement.nature='1' ";