Hi guys I need your help!
I have a site where the user registers and then logs on. The mysql database has the following fields:
id, username, password, email, firstname, name, resultspassion, resultsmotivation, resultspassionorientation
when the user logs on he is offered to do a psychological test with 92 questions. Every question can be answered by clicking a radiogroupbutton, which value is between 0 and 5.
Every value of the answer needs to be saved either in "resultspassion", "resultsmotivation" or "resultspassionorientation".
As an example:
<td width="26">1</td>
<td width="411"><strong>Do you like talking to people?</strong><br />
</b></td>
<td width="230">
<div align="left">
<input name="resultspassion1" type="radio" value="0" />
<input name="resultspassion1" type="radio" value="1" />
1
<input name="resultspassion1" type="radio" value="2" />
2
<input name="resultspassion1" type="radio" value="3" />
3
<input name="resultspassion1" type="radio" value="4" />
4
<input name="resultspassion1" type="radio" value="5" />
5</div></td>
</tr>
<tr>
<td>2</td>
<td>Is it important for you what other people think about you?</b></td>
<td><p>
<label></label>
<label></label>
<input name="resultsmotivation2" type="radio" value="0" />
<input name="resultsmotivation2" type="radio" value="1" />
1
<input name="resultsmotivation2" type="radio" value="2" />
2
<input name="resultsmotivation2" type="radio" value="3" />
3
<input name="resultsmotivation2" type="radio" value="4" />
4
<input name="resultsmotivation2" type="radio" value="5" />
5<br />
<br />
</p></td>
</tr>
<tr>
<td>3</td>
<td class="style1">How high is your level of excitement right now? </td>
<td><p>
<label></label>
<input name="resultspassionorientation3" type="radio" value="0" />
<input name="resultspassionorientation3" type="radio" value="1" />
1
<input name="resultspassionorientation3" type="radio" value="2" />
2
<input name="resultspassionorientation3" type="radio" value="3" />
3
<input name="resultspassionorientation3" type="radio" value="4" />
4
<input name="resultspassionorientation3" type="radio" value="5" />
5<br />
</p></td>
The test goes over three pages. My trouble now is. At the end of the page I have a go on button
<input name="Submit" type="submit" class="style1" value="go on" />
What can I do that
1. the answers are stored dynamically?
2. the values of teh answers are adding each time? (e.g. when I have on one page 10 questions or passion and he has at the end a value of 92 that the script counts all his values for passion together and then puts it in the table or puts each value of each answer in the table and adds them....
Please help!! Thanks!