#mol
$resmol=mysql_query("SELECT categorie.*,molieres.*,rep.idp,pieces.titre FROM rep,molieres,categorie,pieces WHERE idper=$id and rep.idrep=molieres.idrep and categorie.idcat=molieres.idcat and pieces.idp=rep.idp order by molieres.idcat,molieres.annee");
$old=1;
$NbCols=2;
echo "

\n";
$res1=mysql_query("SELECT $TAB2.*,personnes.nomtot,personnes.idper IDPER,annee,rep.idt,rep.idp,rep.idrep,theatres.idt,nomth,pieces.idp,titre,titri,".$TABLES[$k].".* FROM $TAB2,personnes,rep,theatres,pieces,".$TABLES[$k]." WHERE $TABLES[$k].idper=$id and rep.idrep=".$TABLES[$k].".idrep and rep.idt=theatres.idt and rep.idp=pieces.idp and $TAB2.idrep=rep.idrep and $TAB2.idper=personnes.idper order by annee");
echo "