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");
18 while($periode = mysql_fetch_object($periodes))
20 $debut_table .= '<th>'.$periode->nom_abrege
.'</th>';
23 $debut_table .= '<th>remarques</th>
28 echo '<table class="inscrits">';
29 while($participant = mysql_fetch_object($participants))
31 if ($clan_courant !== $participant->clan_nom
)
33 echo ($participant->clan_nom
!= '' ? '<tr><td colspan="'. ($nb_periode +
4) .'"><h1>'.traitement_pre_affichage($participant->clan_nom
).'</h1></td></tr>' : ''), $debut_table;
34 $clan_courant = $participant->clan_nom
;
37 $participations = mysql_query("
38 SELECT periodes.nom, participations.participant_id FROM periodes
39 LEFT JOIN participations ON periodes.id = participations.periode_id AND participations.participant_id = ".$participant->id
."
44 echo '<td>', htmlentities($participant->clan_tag
, ENT_QUOTES
, "UTF-8"), traitement_pre_affichage($participant->pseudo
), '</td>';
45 echo '<td>', traitement_pre_affichage($participant->nom
), '</td>';
46 echo '<td>', traitement_pre_affichage($participant->prenom
), '</td>';
47 while ($participation = mysql_fetch_object($participations))
48 echo '<td '.($participation->participant_id
== $participant->id
? 'class="participe"' : '').'></td>';
50 echo '<td>', traitement_pre_affichage($participant->remarques
), '</td>';