-$res = mysql_query("SELECT pseudo, nom, prenom, age, clan_nom, clan_tag, remarques FROM participants ORDER by clan_nom, clan_tag, pseudo");\r
-\r
+$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