liste_etudiants_examens.php

SELECT session_ta.ID_session_ta,
       session_ta.date_debut,
       session_ta.date_remise_notes,
       session_libelle_ta.libelle
FROM session_ta
INNER JOIN session_libelle_ta ON session_ta.ID_session_libelle = session_libelle_ta.ID_session_libelle_ta
WHERE date_debut <= '".$ZeDate."'
  AND date_remise_notes >= '".$ZeDate."'";

SELECT DISTINCT anet_ta.ID_anet_ta,
                anet_ta.mnemonique,
                anet_ta.special,
                anet_ta.libelle
FROM anet_ta
INNER JOIN inscription_ta ON inscription_ta.ID_anet = anet_ta.ID_anet_ta
INNER JOIN cours_inscription_ta ON cours_inscription_ta.ID_inscription = inscription_ta.ID_inscription_ta
INNER JOIN cours_ta ON cours_inscription_ta.ID_cours = cours_ta.ID_cours_ta
WHERE inscription_ta.anac_insc= $_SESSION['Anac']
  AND cours_ta.mnemonique= $_POST['mnemonique']
ORDER BY mnemonique,
         special;

SELECT DISTINCT cours_inscription_ta.ID_cours_inscr_ta,
                cours_inscription_ta.type_disp,
                inscription_ta.matricule,
                etudiant_ta.nom,
                etudiant_ta.prenom
FROM cours_inscription_ta
INNER JOIN cours_ta ON cours_ta.ID_cours_ta = cours_inscription_ta.ID_cours
INNER JOIN inscription_ta ON inscription_ta.ID_inscription_ta = cours_inscription_ta.ID_inscription
INNER JOIN etudiant_ta ON etudiant_ta.matricule = inscription_ta.matricule
INNER JOIN session_inscription_ta ON inscription_ta.ID_inscription_ta = session_inscription_ta.ID_inscription
WHERE inscription_ta.ID_anet = $LigneAnets['ID_anet_ta']
  AND inscription_ta.anac_insc = $_SESSION['Anac']
  AND session_inscription_ta.inscrit = '1'
  AND session_inscription_ta.ID_session = $_POST['ID_session_ta']
  AND inscription_ta.statut_administratif='1'
  AND cours_ta.mnemonique= $_POST['mnemonique']
ORDER BY etudiant_ta.nom,
         etudiant_ta.prenom ;