QCM sous Mysql,

Bonjour,

je veux creer un qcm avec php en utulisant les deux tables Reponses(id_question,id_reponse) ET reponse_juste (id_question,num_reponse,lib_question)pour la correction et pour donner le score

voila mon code mais ça ne fonctionne pas;

<html>
<head> <title> sans nom</title> </head>
<body>
<?php
$cpt=0;
$idcon = mysql_connect("localhost","root","");
$idbd = mysql_select_db("QCM");
$req1="update reponses
set id_reponse='".$_POST['R1']."'
where id_question=1";
mysql_query($req1,$idcon);
$req2="update reponses
set
id_reponse='".$_POST['R2']."'
where id_question=2";
mysql_query($req2,$idcon);
$req3="update reponses
set
id_reponse='".$_POST['R3']."'
where id_question=3";
mysql_query($req3,$idcon);

$requete1="select num_reponse from reponse_juste where(id_question=1)";
$resultat1=mysql_query($requete1,$idcon);
$requete2="selecte id_reponse from reponses where(id_question=1)";
$resultat2=mysql_query($requete2,$idcon);
if($resultat1==$resultat2)
$cpt++;
echo "$cpt";

?>
</body>
</html>