collect data

suzila

hi there,

My project is about questionnaire. Sorry if you can't understand it very well.
After user select a questionnaire title, it will appear the questionnaire question in HTML format.
My problem is how to collect the data after the user have answer te question? because i want the data to
generate a bar chart just like a "POLL". Thank You very much.

Below is my coding to appear a questionnaire question after user had select the questionnaire title.

<html>
<body >
<form method="post" action="" name="vq">
<?
$connection = mysql_connect("localhost","","");
$pd = mysql_select_db("myEsurvey", $connection);

$vqsql = "SELECT * from questionnaire WHERE title='$poll' ";
$vqresult=mysql_query($vqsql,$connection);

$i=1;
while($row=mysql_fetch_object($vqresult))
{
echo " Soalan-$i : $row->question ";
echo "Jawapan: ";
echo "<input type=\"radio\" name=\"A\" value=\"$row->A\">";
echo "A.$row->A ";
echo "<input type=\"radio\" name=\"B\" value=\"$row->A\">";
echo "B.$row->B ";
echo "<input type=\"radio\" name=\"C\" value=\"$row->A\">";
echo "C.$row->C ";
echo "<input type=\"radio\" name=\"D\" value=\"$row->A\">";
echo "D.$row->D ";
$i++;
}
mysql_close();
?>
<input type="submit" name="submit" value="POLL">
</form></body></html>

simonsky

You may change your code a bit, the "name=" should be a question number and be the same in all 4 choices, then the "value=" is the A,B,C,D, then you will have $Q[1]="A",$Q[2]="D",......so and so.

After that, when user click the submit, you can obtain an array of answers.

echo "<font face=verdana color=#000000 size=1><b>A.</b>$row->A<br></font>"; 
echo "<input type=\"radio\" name=\"Q[$i]\" value=\"A\">"; 
echo "<font face=verdana color=#000000 size=1><b>A.</b>$row->B<br></font>"; 
echo "<input type=\"radio\" name=\"Q[$i]\" value=\"B\">"; 

Simonsky