1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| $sql="SELECT nom_titre FROM question,titre,type,reponse WHERE question.id_question=titre.id_titre AND question.id_question=reponse.id_question AND reponse.id_type=type.id_type AND id_sondage=1 AND type.id_type=1 GROUP BY nom_titre;";
$req= mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
$nb_res=mysql_num_rows($req);
while ($row = mysql_fetch_row($req))
{
$i=0;
echo "<span class='petit_titre'><br />".$row[$i]."</span><br />"; //Titre
$sql_1="SELECT nom_question FROM question,titre WHERE question.id_titre=titre.id_titre AND titre.nom_titre='$row[$i]'";
$req_1= mysql_query($sql_1) or die('Erreur SQL !'.$sql_1.'<br>'.mysql_error());
while ($row_1 = mysql_fetch_row($req_1))
{
$j=0;
echo "<table border=1 class='center_bloc' width='50%'>";
echo "<td>".$row_1[$j]."</td>.</tr>"; //Question
$sql_2="SELECT id_reponse,nom_reponse FROM reponse,question WHERE reponse.id_question=question.id_question AND nom_question='$row_1[$j]'";
$req_2= mysql_query($sql_2) or die('Erreur SQL !'.$sql_2.'<br>'.mysql_error());
while ($row_2 = mysql_fetch_row($req_2))
{
$k=0;
echo "<tr>";
echo "<td align='center'><input type='checkbox' name='tab[]' value='$row_2[$k]' onclick='javascript:checkSelect($row_2[$k]);''><br>".$row_2[1]."</input></td>"; //Réponse
echo "</tr>";
}
echo "</table>";
}
} |