[Summary view] [Print] [Text view]

   1  <?php
   2      $requete_spect= "SELECT representation.id as id_representation, (SELECT date FROM representation
   3                            WHERE representation.id_spectacle=spectacle.id
   4                            ORDER BY date desc LIMIT 1
   5                          ) as date,
   6                          spectacle.id as id, titre, resume, compl_info,
   7                          commentaire, spectacle.media as media, reservation
   8                    FROM representation RIGHT JOIN spectacle
   9                      ON spectacle.id=representation.id_spectacle
  10                    WHERE to_days(date) <= to_days(now())
  11                      GROUP BY spectacle.id
  12                    ORDER BY date desc
  13                  ";
  14  
  15      $requete_repr='select id as id_representation, date, salle, lieu, ville
  16          FROM representation WHERE id_spectacle=$id_spect ORDER BY date desc';
  17  
  18  include  "spect.inc.php";
  19  
  20  ?>