Source de QetRQuartier.php
<?php
require('biblimsm.php');
$connexion = mysql_connect(SERVEUR,UTILISATEUR,MOTDEPASSE);
mysql_select_db(NOMBASE,$connexion);
$requete = "SELECT nom_quartier FROM quartiers WHERE id=$quartier";
$resultat = mysql_query($requete,$connexion);
$nom_quartier = mysql_result($resultat,0,0);
DebutPage("Réponses au quizz - $nom_quartier");
?>
<p>
<table width="700" border="0" cellspacing="0" cellpadding="0" height="100%" align="center">
<?php
$requete = "SELECT * FROM questions WHERE ref_quartier=$quartier ORDER BY id";
$resultat = mysql_query($requete,$connexion);
$num = 0;
while ($question = mysql_fetch_array($resultat)) {
$propositions = array();
$reqprops = 'SELECT * FROM propositions WHERE ref_question='.$question['id'].' ORDER BY id';
$resprops = mysql_query($reqprops,$connexion);
while ($proposition = mysql_fetch_array($resprops)) {
$propositions[] = $proposition;
}
AfficheQuestion(++$num,$question,$propositions,TRUE);
}
?>
<tr>
<td width="25"> </td>
<td> </td>
</tr>
<tr>
<td align=center width="25"> </td>
<td align=center> </td>
</tr>
</table>
<?php
mysql_close($connexion);
PiedPage();
?>