1 2 3 4 5 6 7 8 9 10 11 12 13
| <?PHP $reponse = mysql_query("SELECT DISTINCT libelle,nom,prenom,numsalle,nommatiere,heure,jour,typecours
FROM reservation AS R,matiere,professeur,salle,jour,heure,type,semaine
WHERE
R.professeurid = professeur.id
AND jourid = '1'
AND heureid = '1'
AND typeid = type.id
AND matiereid = matiere.id
AND salleid= salle.id
AND semaineid = '" . $_POST['semaine'] . "' limit 1");
while($data=mysql_fetch_array($reponse))
echo $data['nom'].' '.$data['prenom'].' '.$data['nommatiere'].' '.$data['numsalle'];
?> |
Partager