How to calculate mark using check box

[asymtotes]

hello n gud day every one

basically my project is about personality test, it content 6 page of question which each page has 13 question

page 1
-----------------------

question 1 checkbox1
question 2 checkbox2
.
.
.
.
.
question 13 checkbox13
-------------------------------

once user click on next page, system will calculate number of checked check box and display the value on result page

and i having a problem to calculate number of checked checkbox in php.

i hope u guys can help me~

below is some of my code to retrieve data from dtbase

  <?php mysql_select_db("esci", $conn);
        $result = mysql_query("SELECT * FROM personality_rule WHERE conclusion = 'Realistic'");    
    while($data = mysql_fetch_array($result))
      {
    $rules = str_replace("_"," ",$data['question']);
      echo'
     <tr>
     <td>'. $rules.'</td>
     <td align="center"><input type="checkbox" name="ans"/></td>
     </tr>
     ';
     }
     ?>

[dlite922]

since question - answer are pairs, you need something to tie those two together.

I can't get much from what you said or your code, but let's say you have a questions table. each question has an ID, and also a column perhaps if the question has finite set of answers. (i.e. A= Agree, B =Disagree, C = Don't care, etc)

You should store your answers in a another table that has that question ID and the value of the answer, be it an option, free text or a boolean Yes/No.

Your html input tag's name should somehow tie the answer to the question it answers.

for example:

<input type="radio" name="questionID_1" value=""/>
 
// or 
 
<input type="text" name="questionID_442" value="" /> 
 
 

Store the answer values in the session or in a table after each page, it's up to you.


Dan

[MusoFreak200]

@ dlite922

that is a good idea i never thought of doing it that simple...

thanks...