pseudo nom prénom'; while($periode = mysql_fetch_object($periodes)) $debut_table .= ''.$periode->nom_abrege.''; $debut_table .= 'remarques '; $clan_courant = null; 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), ''; while ($participation = mysql_fetch_object($participations)) echo 'participant_id == $participant->id ? 'class="participe"' : '').'>'; echo '', traitement_pre_affichage($participant->remarques), ''; echo ''; } echo ''; ?>