form checkboxes different names each into multiple rows database [closed]
- by Darlene
Hi i've been at this for hours and need help. Thanks in advice.
i have the following tables:
tblprequestion
quesid| ques
tblanswers
answerid|quesid | ans |date
This is my form:
prequestion form
<?php
$con = mysql_connect("localhost","root","") or die ("Could not connect to DB Server");
$db_selected = mysql_select_db("nbtsdb", $con) or die("Could not locate the DB");
$query3= mysql_query("SELECT * FROM tblprequestions", $con)
or die("Cannot Access prequestions description from Server");
echo"<legend> Pre question :</legend>";
echo"<p></p>";
while($row = mysql_fetch_array($query3))
{
echo"<p>";
echo"<input type='checkbox' name='question".$row['quesid']."[]' value='yes'
/>";
echo"<label>".$row['ques']."</label> ";
echo"</p>";
}
echo"<p></p>";
?>
i would like to know how to get the values from the form for each question (total of 17) to submit into the database.
for example
tblprequestion
quesid| ques
1 Had a cold or fever in the last week?
2 Had minor outpaient surgery?
tblanswers
answerid|username |quesid | ans |date
1 lisa 1 yes 10/10/12
2 lisa 2 no 10/10/12
