exam form issues

manpreet Best Answer 2 years ago

i am really new on php. I try to make and examination project with php but i have some issues. I have exam form and this form have different type of inputs. For example some questions have combobox, some questions have textarea. I wrote my form code and i wanna learn how can i get all values from the form to the database.

my codes :

$question_id = $question_list['question_id'];
$answer_query = mysql_query("SELECT * FROM answers where question_id = $question_id ORDER BY answer_id ASC");
$total_answers = mysql_num_rows($answer_query);
if ($total_answers > 1)
{
<select name="answers[]" id="answers">                                          <option value="x">please select oneoption>
while ($answer_list = mysql_fetch_array($answer_query)) {
<option value="">PHP echo $answer_list_list['answer_value']; ?>option>

else
{
while ($answer_list = mysql_fetch_array($answer_query)) {
<textarea name="answers[]" id="answers" rows="5" cols="100">textarea>

so this is my answer listing part of my exam form. So as you see combobox values getting from database but textarea values will be filled by the users. So how can i get all values (answers from database in combobox (selected value) and textarea values which will be filled by users).