X-Git-Url: http://git.euphorik.ch/index.cgi?a=blobdiff_plain;f=php%2Ftx_inscrits.php;fp=php%2Ftx_inscrits.php;h=89ff6a0c3c6bb8bce7eca953a8f5278b53041141;hb=27f3004da65f2b5803709b3fa76a791c9b38a0c9;hp=0000000000000000000000000000000000000000;hpb=262be7e249593a2764a7c452f70dc5ac68887d5c;p=cl7.git

diff --git a/php/tx_inscrits.php b/php/tx_inscrits.php
new file mode 100644
index 0000000..89ff6a0
--- /dev/null
+++ b/php/tx_inscrits.php
@@ -0,0 +1,36 @@
+<?php # coding:utf-8
+
+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");
+
+$debut_table = '
+<table class="inscrits">
+ <tr>
+  <th>pseudo</th>
+  <th>nom</th>
+  <th>prénom</th>
+  <th>age</th>
+  <th>remarques</th>
+ </tr>';
+ 
+$clan_courant = null;
+
+while($participant = mysql_fetch_object($res))
+{  
+   if ($clan_courant !== $participant->clan_nom)
+   {
+      echo ($participant->clan_nom != '' ? '</table><h1>'.traitement_pre_affichage($participant->clan_nom).'</h1>' : ''), $debut_table;
+      $clan_courant = $participant->clan_nom;
+   }
+   
+   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>';
+	echo '<td>', traitement_pre_affichage($participant->age), '</td>';
+	echo '<td>', traitement_pre_affichage($participant->remarques), '</td>';
+	echo '</tr>';
+}
+echo '</table>';
+?>