Hi - This is my first attempt at learning myself php/dreamweaver. I have made two tables in sql
QUESTIONS - Topic, questionid, questiontext
ANSWERS - questonid, answer1, answer2, answer3, answer4, correctanswer
I've then made in dreamweaver a simple page that users two recordsets - one for the question table and one for the answers table
I then made two tables and put in the fist the recordset = QuestionId
In the second I put in the recordset = answer1, answer2, answer3, answer 4
In the sql tables there are 20 questions and 80 possible answers but I have set it so you can only view the questions in a certain topic - always 5 questions per topic
So now I have 2 tables each with one row:
questiontext ------ answer1, answer2, answer3, answer4
but then i've put a repeat region around this table so on runtime I can view all five questions (one per row) and 4 options for each question ?(four per row)
Then in each colum where the four possible answers are there are also a radio button - so the user can pick one answer for each row - if I take out the repeat region thing it works but as soon as i put that in I can only choose one radio button out of all 20 instead of one per row
The attachment i added might make a little more sence - I hope this helps explain my problem 🙂