la mémoire du théâtre
Association de la Régie Théâtrale
   
  Création
".$Day." ".$Month." ".$Year."
\n"); } else { printf("\n"); } ?> \n"; ?> \n"; ?> "; /* molieres */ echo "

Reprise
".$Day." ".$Month." ".$Year."
\n"); } } if ($Apart2!="0000-00-00") { printf("
Dernière
".$Day2." ".$Month2." ".$Year2."

\n"); } if ($NBREP!="") { printf("".$NBREP." Représentations
\n"); } if ($DUREE!="") { printf("
Durée du spectacle ".$DUREE."\n"); } if ($HORAIRE!="") { printf("
Horaire ".$HORAIRE."
Reprise : ".$rowc["annee"]."\n"); } else { printf("
Création : ".$rowc["annee"]."\n"); } } } echo "
0) { $affiche="../../affiches_theatre/photos/".$idaff.".jpg"; echo "
\n"; } } /* maquette */ $mak=mysql_query("select maquette from rep where idrep=$id"); while ($rowmak=mysql_fetch_array($mak)) { $idmak=$rowmak["maquette"]; if ($idmak > 0) { printf("voir les maquettes
\n"); } } /* avant scene */ $resav=mysql_query("select numavs,couv,idas,article from avantscenes where idas=$id"); $nbav=mysql_query("select idas from avantscenes where idas=$id"); $rownb=mysql_num_rows($nbav); if ($rownb >=1) { while ($rowav=mysql_fetch_array($resav)) { if ($rowav["couv"]=="oui") { $color="#FF0000"; $type="Texte édité"; } else { $color="#0000FF"; $type="Article de presse"; } echo "
".$type."
Avant-scène Nœ ".$rowav["numavs"]."
\n"; } } /* programme */ $resp=mysql_query("SELECT no FROM prog WHERE idrep=$id"); $rowp=mysql_fetch_array($resp); if ($rowp["no"] != "0") { echo "
Programme n° ".$rowp["no"]."\n"; } /* releves mise en scène */ $resr=mysql_query("SELECT no FROM releves WHERE idrep=$id"); $rowr=mysql_fetch_array($resr); if ($rowr["no"] !="0") { echo "
Relevé de mise en scène n° ".$rowr["no"]."\n"; } echo "
\n"; echo $NOMS[$i].""; $old = $NOMS[$i]; } echo "".$NOMTOT[$i]." - \n"; } } } } echo "
\n"; echo "
"; $old=1; $resmol=mysql_query("select idrep from molieres where idrep=$id"); $rowmol=mysql_num_rows($resmol); if ($rowmol >=1) { $res12=mysql_query("SELECT categorie.*,molieres.*,personnes.nomtot FROM molieres,categorie,personnes where idrep=$id and prix='on' and categorie.idcat <8 and categorie.idcat=molieres.idcat and personnes.idper=molieres.idper order by molieres.idcat"); while ($row12=mysql_fetch_array($res12)) { echo "
Molière ".$row12["annee"]."
\n"; if ($old != $row12["nom"]) { echo "".$row12["nom"]."
\n"; $old=$row12["nom"]; } echo "".$row12["nomtot"]."
\n"; } $res13=mysql_query("SELECT distinct(molieres.idrep),categorie.*,molieres.idcat,annee FROM molieres,categorie where idrep=$id and prix='on' and categorie.idcat >7 and categorie.idcat=molieres.idcat order by molieres.idcat"); while ($row13=mysql_fetch_array($res13)) { echo "
Molière ".$row13["annee"]."
\n"; echo "".$row13["nom"]."
\n"; } $res14=mysql_query("SELECT molieres.*,categorie.*,personnes.nomtot FROM molieres,categorie,personnes where idrep=$id and prix='off' and categorie.idcat <8 and categorie.idcat=molieres.idcat and molieres.idper=personnes.idper order by molieres.idcat"); while ($row14=mysql_fetch_array($res14)) { if ($old != $row14["nom"]) { echo "
Nomination Molière ".$row14["annee"]."
\n"; echo "".$row14["nom"]."
\n"; $old = $row14["nom"]; } echo "".$row14["nomtot"]."
\n"; } $res15=mysql_query("SELECT molieres.*,categorie.* FROM molieres,categorie where idrep=$id and prix='off' and categorie.idcat >7 and categorie.idcat=molieres.idcat group by molieres.idcat order by molieres.idcat"); while ($row15=mysql_fetch_array($res15)) { echo "
Nomination Molière ".$row15["annee"]."
\n"; echo "".$row15["nom"]."\n"; } } ?>
0) { echo "

Distribution

\n"; echo "
\n"; for ($i=0;$i<$NB;$i++) { printf("".$ACT[$i]." (".$ROLE[$i].") - \n"); } echo "
\n"; } echo "
"; $resum=mysql_query("SELECT resume from rep where IDREP=$id"); $row4=mysql_fetch_array($resum); if ($RESUME !="") { echo "

Résumé

"; echo "
".$RESUME."
\n"; } ?>

 

 
  haut de page  
accueil
theatres
molières


comedia
contactez-nous
nous écrire
Vous ne trouvez pas ?
Essayez :

Les Archives
du
Spectacles
Plan du site