1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| $salle=$_GET["lst_salle"];
$_SESSION["salle"]=$salle;
$requete="SELECT dateConcert, prenomArtiste, nomArtiste
FROM salle s, concert c, artiste a
WHERE s.nomSalle='$salle'
and s.noSalle=c.noSalle
and c.noArtiste=a.noArtiste
order by c.dateConcert, a.noArtiste";
$curseur=mysql_query($requete);
while($data=mysql_fetch_array($curseur)){
echo"<table border='1' width='30%'><th>'Artiste'</th><th>'Date'</th><tr><td width='50%'>";
echo $data['prenomArtiste'];
echo " ";
echo $data['nomArtiste'];
echo "</td><td>";
echo $data['dateConcert'];
echo "</td></tr></table>";
} |
Partager