1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| <?
$sql = "SELECT t_instruction.id_instruction, t_instruction.date_d, t_instruction.nbr_candidats, reservistes.id_res, reservistes.nom, grades.grades as grade
FROM t_instruction
INNER JOIN t_instruction_candidats ON t_instruction.id_instruction = t_instruction_candidats.id_instruction
LEFT JOIN reservistes ON t_instruction_candidats.id_res = reservistes.id_res
LEFT JOIN grades ON reservistes.id_grades = grades.id_grades
ORDER BY date_d ASC, t_instruction.id_instruction ASC, nom ASC";
$true = mysql_num_rows($req);
if ($true == 0 ) exit;
$id_courant = null;
while ($result = mysql_fetch_array ($req)) {
// si on a change de groupe
if ($id_courant != $result['id_instruction']) {
echo "<h3><a href=\"#\">".$tab_jours[$jour]." ".datefr($result['date_d'])." - ".$nbr_inscrit." inscrit(s) pour ".$result['nbr_candidats']." places</a></h3>";
$id_courant = $result['id_instruction'];
}
//affichage du candidat
?>
<li><? echo $result['nom'];?> (<? echo $result['grade'];?>) <a href="index_admin.php?page=admin_instruction.php&id_instruction=<? echo $result['id_instruction'];?>&id_res=<? echo $result['id_res'];?>=&supp_res=1" onclick="return doconfirm('Ceci supprimera le réserviste de l\'instruction.');"><img src="images/Delete.png" width="15" height="15" title="Supprimer"></a></li>
<?
} |
Partager