<?php

require('biblimsm.php');

DebutPage('Enregistrement d\'une question');


// Connexion à la base

$connexion = mysql_connect(SERVEUR,UTILISATEUR,MOTDEPASSE);
mysql_select_db(NOMBASE,$connexion);


// Insertion de la nouvelle question

$requete  = "INSERT INTO questions VALUES ('','$formulation',$quartier,0)";
mysql_query($requete,$connexion);



// Insertion des réponses

$requete     = "SELECT MAX(id) FROM questions";
$resultat    = mysql_query($requete,$connexion);
$id_question = mysql_result($resultat,0,0);

for ($i=1 ; $i<=7 ; $i++) {

  if ($prop[$i] != '') {
    $requete  = "INSERT INTO propositions VALUES ('','$prop[$i]',$id_question)";
    mysql_query($requete,$connexion);

    if ($i == $br) {
      $requete     = "SELECT MAX(id) FROM propositions";
      $resultat    = mysql_query($requete,$connexion);
      $id_br       = mysql_result($resultat,0,0);
      $requete  = "UPDATE questions SET reponse=$id_br WHERE id=$id_question";
      mysql_query($requete,$connexion);
    }

  }
}




// Récupération des infos pour vérification

$requete  = "SELECT * FROM questions WHERE id=$id_question";
$resultat = mysql_query($requete,$connexion);
$question = mysql_fetch_array($resultat);

$requete  = "SELECT * FROM propositions WHERE ref_question=$id_question";
$resultat = mysql_query($requete,$connexion);

while ($proposition = mysql_fetch_array($resultat)) {
  $propositions[] = $proposition;
}

?>
<p>&nbsp;
<table width="700" border="0" cellspacing="0" cellpadding="0" height="100%" align="center">

<?php

AfficheQuestion(1,$question,$propositions,FALSE);
AfficheQuestion(1,$question,$propositions,TRUE);

?>

  <tr> 
    <td width="25">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr> 
    <td align=center width="25">&nbsp;</td>
    <td align=center>&nbsp;</td>
  </tr>
</table>

<?php

// Déconnexion et fin de page

mysql_close($connexion);

PiedPage();


?>