-<?php # coding:utf-8\r
-\r
-include_once("traitement_pre_affichage.php");\r
-\r
+<?php # coding:utf-8
+
+include_once("traitement_pre_affichage.php");
+
$participants = mysql_query("
SELECT id, pseudo, nom, prenom, clan_nom, clan_tag, remarques
FROM participants
ORDER by clan_nom, clan_tag, pseudo
-");\r
+");
-$periodes = mysql_query("SELECT nom_abrege FROM periodes ORDER BY id");\r
-$debut_table = '\r
-<table class="inscrits">\r
- <tr>\r
- <th>pseudo</th>\r
- <th>nom</th>\r
+$periodes = mysql_query("SELECT nom_abrege FROM periodes ORDER BY id");
+$debut_table = '
+ <tr>
+ <th>pseudo</th>
+ <th>nom</th>
<th>prénom</th>';
+$nb_periode = 0;
while($periode = mysql_fetch_object($periodes))
- $debut_table .= '<th>'.$periode->nom_abrege.'</th>';\r
-$debut_table .= '<th>remarques</th>\r
- </tr>';\r
- \r
-$clan_courant = null;\r
-\r
-while($participant = mysql_fetch_object($participants))\r
-{ \r
- if ($clan_courant !== $participant->clan_nom)\r
- {\r
- echo ($participant->clan_nom != '' ? '</table><h1>'.traitement_pre_affichage($participant->clan_nom).'</h1>' : ''), $debut_table;\r
- $clan_courant = $participant->clan_nom;\r
+{
+ $debut_table .= '<th>'.$periode->nom_abrege.'</th>';
+ $nb_periode++;
+}
+$debut_table .= '<th>remarques</th>
+ </tr>';
+
+$clan_courant = null;
+
+echo '<table class="inscrits">';
+while($participant = mysql_fetch_object($participants))
+{
+ if ($clan_courant !== $participant->clan_nom)
+ {
+ echo ($participant->clan_nom != '' ? '<tr><td colspan="'. ($nb_periode + 4) .'"><h1>'.traitement_pre_affichage($participant->clan_nom).'</h1></td>' : ''), $debut_table;
+ $clan_courant = $participant->clan_nom;
}
$participations = mysql_query("
SELECT periodes.nom, participations.participant_id FROM periodes
LEFT JOIN participations ON periodes.id = participations.periode_id AND participations.participant_id = ".$participant->id."
ORDER BY id
- ");\r
- \r
- echo '<tr>';\r
- echo '<td>', htmlentities($participant->clan_tag, ENT_QUOTES, "UTF-8"), traitement_pre_affichage($participant->pseudo), '</td>';\r
- echo '<td>', traitement_pre_affichage($participant->nom), '</td>';\r
+ ");
+
+ echo '<tr>';
+ echo '<td>', htmlentities($participant->clan_tag, ENT_QUOTES, "UTF-8"), traitement_pre_affichage($participant->pseudo), '</td>';
+ echo '<td>', traitement_pre_affichage($participant->nom), '</td>';
echo '<td>', traitement_pre_affichage($participant->prenom), '</td>';
while ($participation = mysql_fetch_object($participations))
echo '<td '.($participation->participant_id == $participant->id ? 'class="participe"' : '').'></td>';
- \r
- echo '<td>', traitement_pre_affichage($participant->remarques), '</td>';\r
- echo '</tr>';\r
-}\r
-echo '</table>';\r
-?>\r
+
+ echo '<td>', traitement_pre_affichage($participant->remarques), '</td>';
+ echo '</tr>';
+}
+echo '</table>';
+?>
+