X-Git-Url: http://git.euphorik.ch/index.cgi?a=blobdiff_plain;ds=inline;f=php%2Ftx_inscrits.php;h=eac839016a2d1f9bc9426b8c8613c95a409fcaf1;hb=eb13d74a54796fabaa4034eeb2e803f41c7424ab;hp=89ff6a0c3c6bb8bce7eca953a8f5278b53041141;hpb=9f4608bb190f3cd49c45aefbb4076182a1449cf8;p=cl7.git
diff --git a/php/tx_inscrits.php b/php/tx_inscrits.php
index 89ff6a0..eac8390 100644
--- a/php/tx_inscrits.php
+++ b/php/tx_inscrits.php
@@ -2,33 +2,47 @@
include_once("traitement_pre_affichage.php");
-$res = mysql_query("SELECT pseudo, nom, prenom, age, clan_nom, clan_tag, remarques FROM participants ORDER by clan_nom, clan_tag, pseudo");
-
+$participants = mysql_query("
+ SELECT id, pseudo, nom, prenom, clan_nom, clan_tag, remarques
+ FROM participants
+ ORDER by clan_nom, clan_tag, pseudo
+");
+
+$periodes = mysql_query("SELECT nom_abrege FROM periodes ORDER BY id");
$debut_table = '
pseudo |
nom |
- prénom |
- age |
- remarques |
+ prénom | ';
+while($periode = mysql_fetch_object($periodes))
+ $debut_table .= ''.$periode->nom_abrege.' | ';
+$debut_table .= 'remarques |
';
$clan_courant = null;
-while($participant = mysql_fetch_object($res))
+while($participant = mysql_fetch_object($participants))
{
if ($clan_courant !== $participant->clan_nom)
{
echo ($participant->clan_nom != '' ? '
'.traitement_pre_affichage($participant->clan_nom).'
' : ''), $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
+ ");
echo '';
echo '', htmlentities($participant->clan_tag, ENT_QUOTES, "UTF-8"), traitement_pre_affichage($participant->pseudo), ' | ';
echo '', traitement_pre_affichage($participant->nom), ' | ';
- echo '', traitement_pre_affichage($participant->prenom), ' | ';
- echo '', traitement_pre_affichage($participant->age), ' | ';
+ echo '', traitement_pre_affichage($participant->prenom), ' | ';
+ while ($participation = mysql_fetch_object($participations))
+ echo 'participant_id == $participant->id ? 'class="participe"' : '').'> | ';
+
echo '', traitement_pre_affichage($participant->remarques), ' | ';
echo '
';
}