Posted by Gdell on 10/21/31 11:51

Thank you I will try it out.



"Rik" <luiheidsgoeroe@hotmail.com> wrote in message
news:711f1$44a19ad7$8259c69c$19906@news1.tudelft.nl...
> Garry wrote:
>> I am trying to create a multiple choice test based on a MySQL
>> database in PHP and presenting just one question at a time for the
>> user to read and slect the correct answer. If the correct answer is
>> selected a congratulatory message is displayed and the correct count
>> is incremented. If an incorrect answer is chosen, then display the
>> correct answer. In both cases increment the question count and move
>> on to the next question.
>>
>> The main reason for storing the questions in MySQL is to create a
>> generic test wrapper that can be used for any kind of Multiple choice
>> test.
>>
>>
>> Thank you if you have any idea on how I can process just onbe
>> (Row/Question) at a time.
>
> So, your problem isn't that you want to process the results individually,
> you want only 1 row from the database. Assuming you want to let them see
> only one question, and then submit a form to the next page?
>
> Possible solutions:
> - add a field called 'question_number" or something, and query 'SELECT
> question, answer FROM table WHERE questionnumber = the variable. The
> variable could be increased after every answer, possibly using a GET or
> POST
> variable.
>
> - You could use a LIMIT $start, 1 at the end of your query, where $start
> is
> also incremented after every question, again a GET or POST variable seems
> logical.
>
> If you want to use MySQL, I would suggest reading some tutorials on SQL /
> query-building. If you want only one row, the SQL should give you only
> one,
> don't try to let PHP sort it out.
>
> Grtz,
> --
> Rik Wasmus
>
>

[Back to original message]