Hi everyone!

The tables given below shows that every rows in the 'questions' table is assigned to four rows in the 'answers' table. I wonder how to select randomly four questions and sixteen answers and then display them separately. I want to gain the following effect:

first site:
1 question - 1 answer
- 1 answer
- 1 answer
- 1 answer

second site:
3 question - 3 answer
- 3 answer
- 3 answer
- 3 answer

third site:
2 question - 2 answer
- 2 answer
- 2 answer
- 2 answer

fourth site:
4 question - 4 answer
- 4 answer
- 4 answer
- 4 answer

If I write this query:
SELECT question FROM questions WHERE epoch_id = 2 AND id = 4;
then the result is:
question number 4

If I write this query:
SELECT answer FROM questions JOIN answers ON questions.epoch_id = 2 AND questions.id=answers.question_id AND answers.question_id = 4;
then the result is four times:
answer number 4
answer number 4
answer number 4
answer number 4

What do I have to do if I want to gain more rows from the 'answers' table?

Please help.
Thanks in advance for yours reply.


BELOW TABLE - structure
1. TABLE epochs: epoch, date_, refer_to_picture, title_picture, author_picture;
2. TABLE questions: epoch_id, question, date_;
3. TABLE answers: question_id, answer, boolean_type, date_;