3 include_once("traitement_pre_affichage.php");
5 $participants = mysql_query("
6 SELECT id, pseudo, nom, prenom, clan_nom, clan_tag, remarques
8 ORDER by clan_nom, clan_tag, pseudo
11 $periodes = mysql_query("SELECT nom_abrege FROM periodes ORDER BY id");
13 <table class="inscrits">
18 while($periode = mysql_fetch_object($periodes))
19 $debut_table .= '<th>'.$periode->nom_abrege
.'</th>';
20 $debut_table .= '<th>remarques</th>
25 while($participant = mysql_fetch_object($participants))
27 if ($clan_courant !== $participant->clan_nom
)
29 echo ($participant->clan_nom
!= '' ? '</table><h1>'.traitement_pre_affichage($participant->clan_nom
).'</h1>' : ''), $debut_table;
30 $clan_courant = $participant->clan_nom
;
33 $participations = mysql_query("
34 SELECT periodes.nom, participations.participant_id FROM periodes
35 LEFT JOIN participations ON periodes.id = participations.periode_id AND participations.participant_id = ".$participant->id
."
40 echo '<td>', htmlentities($participant->clan_tag
, ENT_QUOTES
, "UTF-8"), traitement_pre_affichage($participant->pseudo
), '</td>';
41 echo '<td>', traitement_pre_affichage($participant->nom
), '</td>';
42 echo '<td>', traitement_pre_affichage($participant->prenom
), '</td>';
43 while ($participation = mysql_fetch_object($participations))
44 echo '<td '.($participation->participant_id
== $participant->id
? 'class="participe"' : '').'></td>';
46 echo '<td>', traitement_pre_affichage($participant->remarques
), '</td>';