1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88
| <?php
//Année en cours
$resultannee= mysql_query("
SELECT id_annee
FROM annee
WHERE en_cours = '1'
");
$idannee=mysql_fetch_array($resultannee);
$annee = $idannee["id_annee"];
//Fin
$result75 = mysql_query("
SELECT nom_branche,id_branche
FROM branches
WHERE id_branche IN
(
SELECT id_branche
FROM cours
WHERE id_cours IN
(
SELECT id_cours
FROM cotes
WHERE id_personne = '$_GET[id_user]' and id_annee = '$annee'
))
order by id_branche
");
$result74 = mysql_query("
SELECT DISTINCT id_cours ,id_branche
FROM cours
WHERE id_cours IN
(
SELECT id_cours
FROM cotes
WHERE id_personne = '$_GET[id_user]' and id_annee = '$annee'
)
ORDER BY id_branche
");
while($data2 = mysql_fetch_array($result75)) {
echo $data2["nom_branche"]; ?><br><?php
while ($data = mysql_fetch_array($result74)) {
$result10 = mysql_query("
SELECT nom_cours,id_branche
FROM cours
WHERE id_cours = '$data[id_cours]'
ORDER BY id_branche
");
$resultat10 = mysql_fetch_array($result10);
echo $resultat10["nom_cours"];
$result6 = mysql_query("
SELECT AVG(points*5) AS cotes
FROM cotes
WHERE id_personne = '$_GET[id_user]' and id_cours = '$data[id_cours]' and id_annee = '$annee' and id_periode IN
(
SELECT id_periode
FROM comporter
WHERE num ='1' and id_annee = '$annee'
)
");
$resultat6 = mysql_fetch_array($result6);
echo $resultat6["cotes"]; ?>/100<?php
?></br><?php
}
}
?> |
Partager