pseudo nom prénom'; $nb_periode = 0; while($periode = pg_fetch_object($periodes)) { $debut_table .= ''.$periode->nom_abrege.''; $nb_periode++; } $debut_table .= 'remarques '; $clan_courant = "PHP c'est du CACA"; echo ''; while($participant = pg_fetch_object($participants)) { if ($clan_courant !== $participant->clan_nom) { echo ($participant->clan_nom != '' ? '' : ''), $debut_table; $clan_courant = $participant->clan_nom; } $participations = pg_query_params(" SELECT periodes.nom, participations.participant_id FROM periodes LEFT JOIN participations ON periodes.id = participations.periode_id AND participations.participant_id = $1 ORDER BY id ", array($participant->id)); echo ''; echo ''; echo ''; echo ''; while ($participation = pg_fetch_object($participations)) echo ''; echo ''; echo ''; } echo '

'.traitement_pre_affichage($participant->clan_nom).'

', htmlentities($participant->clan_tag, ENT_QUOTES, "UTF-8"), traitement_pre_affichage($participant->pseudo), '', traitement_pre_affichage($participant->nom), '', traitement_pre_affichage($participant->prenom), 'participant_id == $participant->id ? 'class="participe"' : '').'>', traitement_pre_affichage($participant->remarques), '
'; ?>