Quiz Structure PHP

Teddy Bear's Picnic

Quiz

SELECT t.quizTopicId, t.quizTopic FROM quiztopics AS t WHERE t.quizActive = "Y"

Topic: Teddy Bears

SELECT q.quizQuestionsId, q.quizQuestion FROM quizquestions AS q WHERE q.quizTopicId = 1 ORDER BY q.quizQuestionsId

  1. Why did the teddy bears go into the woods today?
  2. SELECT a.quizAnswer, a.quizAnswerCorrectFlag FROM quizanswers AS a WHERE a.quizQuestionsId=1 ORDER BY a.quizAnswersId
    1. To have a square dance
    2. To play hide and seek
    3. To have a picnic
    4. To play tennis

  3. What is the teddy bear's favourite food?
  4. SELECT a.quizAnswer, a.quizAnswerCorrectFlag FROM quizanswers AS a WHERE a.quizQuestionsId=2 ORDER BY a.quizAnswersId
    1. Peanut Butter
    2. Vegemite
    3. Salami
    4. Honey

  5. What colour fur is most popular in Teddy Bears?
  6. SELECT a.quizAnswer, a.quizAnswerCorrectFlag FROM quizanswers AS a WHERE a.quizQuestionsId=3 ORDER BY a.quizAnswersId
    1. Purple
    2. Gold
    3. Rainbow
    4. Orange
Submit Answers
Please Answer Quiz
Current User: admin
Is Admin: Y



Comments