la mémoire du théâtre
Association de la Régie Théâtrale
   
  \n"; echo "\n"; echo "

Nominations Molière ".$annee."

Les lauréats sont en rouge clair
\n"; echo "

\n"; echo "Palmarès\n"; $res4=mysql_query("select annee from molieres group by annee"); while ($row4=mysql_fetch_array($res4)) { echo " ".$row4["annee"]." \n"; } echo "


\n"; $NbCols=0; echo "\n"; $cat=mysql_query("select count(molieres.idcat) as nb,nom,molieres.idcat from molieres,categorie where annee=$annee and categorie.idcat=molieres.idcat group by molieres.idcat"); while ($CAT=mysql_fetch_array($cat)) { $NBC=$CAT[nb]; $nom=$CAT["nom"]; $idcat=$CAT["idcat"]; if ($NbCols%2==0) { if ($NbCols) echo "\n"; printf("\n"); } echo "\n"; $NbCols++; } echo "
".$nom."
\n"; echo "

\n"; echo "

\n"; echo "

\n"; $NB=0; $res=mysql_query("select categorie.*,personnes.nomtot,molieres.*,rep.idrep,rep.idt,rep.idp,theatres.nomth,pieces.titre from categorie,molieres,rep,pieces,theatres,personnes WHERE molieres.annee='$annee' and molieres.idcat <200 and molieres.idrep=rep.idrep and theatres.idt=rep.idt and pieces.idp=rep.idp and personnes.idper=molieres.idper and categorie.idcat=molieres.idcat order by molieres.idcat"); while ($row=mysql_fetch_array($res)) { $idcat=$row["idcat"]; $titre=$row["titre"]; $thea=$row["nomth"]; $idrep=$row["idrep"]; $idt=$row["idt"]; $nomtot=$row["nomtot"]; $idper=$row["idper"]; $nom=$row["nom"]; $annee=$row["annee"]; if ($row["prix"]=="on") { $color="#FF0000"; } else { $color="#0"; } if ($old != $idcat) { echo "\n"; echo "\n"; $old = $idcat; } echo "\n"; } $resth=mysql_query("select nomth,rep.idrep,rep.idt from theatres,rep where idrep=$idrep and rep.idt=theatres.idt group by rep.idt"); while ($thea=mysql_fetch_array($resth)) { $IDT=$thea["idt"]; $THEA=$thea["nomth"]; echo "".$THEA." - \n"; } echo "
 
".$nom."
".$annee." - ".$nomtot." - "; echo "".$titre." - ".$thea." -
\n"; $res3=mysql_query("select rep.idp,categorie.*,molieres.*,rep.idrep,pieces.titre from molieres,rep,pieces,categorie WHERE molieres.idcat > 199 and molieres.annee=$annee and molieres.idrep=rep.idrep and pieces.idp=rep.idp and categorie.idcat=molieres.idcat order by molieres.idcat"); $Old = 1; echo "
\n"; while ($myrow = mysql_fetch_array($res3)) { if ($myrow["prix"]=="on") { $color="#FF0000"; } else { $color="#0"; } $debut = $myrow["nom"]; $id = $myrow["idcat"]; $annee=$myrow["annee"]; $idrep=$myrow["idrep"]; $idp=$myrow["idp"]; if ($Old != $debut) { echo "\n"; printf("\n"); $Old = $debut; $Old2 = 2; } if ($Old2 != $myrow["titre"]) { echo "\n"; echo "
 
".$debut."
".$annee." - ".$myrow["titre"]." - "; $Old2 = $myrow["titre"]; } $rth=mysql_query("select molieres.annee,nomth,rep.idrep,rep.idt from molieres,theatres,rep where rep.idrep=$idrep and molieres.annee=$annee and molieres.idrep=rep.idrep and rep.idt=theatres.idt group by rep.idt"); while ($rowt=mysql_fetch_array($rth)) { $IDT=$rowt["idt"]; $THEA=$rowt["nomth"]; echo "".$THEA." - "; } } echo "
\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