<? $query = mysql_query("SELECT nom from trombi_name")or die(mysql_error()); while ($sql=mysql_fetch_array($query)){ $nom[]=$sql['nom']; } foreach($nom as $name){ $sql = "SELECT trombi_name.id_name, trombi_name.nom, trombi_experience.id_experience, trombi_experience.id_name, trombi_experience.anne, trombi_experience.fonction FROM trombi_name, trombi_experience WHERE trombi_name.id_name=trombi_experience.id_name and trombi.name = $name ORDER BY trombi_name.id_name "; $result = mysql_query($sql) or die ('Erreur : '.mysql_error() ); while ( $list = mysql_fetch_array( $result ) ) { echo ' '.$list['id_name'].' / - '.$list['nom'].' - '.$list['anne'].' - '.$list['fonction'].' <br> '; } } ?>
Essaye un truc comme ca
