Databases
StackOverflow2013
Postsdbo
POshow multiple choice questions with answers to user
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POshow multiple choice questions with answers to user
    primarykey
    data
    text
    <p>i have a problem about displaying multiple choice questions to user. i have the following tables:</p> <p><strong>multiple_choice_questions</strong> (quiz_id, question,c_answer) this table have the questions with the right answers</p> <p><strong>multiple_choice_answers</strong> (answer_id, quiz_id,answer) this table have the answers with the foreign key quiz_id</p> <p><strong>multiple_choice_info</strong> (info_id,quiz_id,name,class, lesson, subject, notes,date) here are basic informations for each quiz which actually helps in choosing the appropriate quiz from the user. e.g. if a user puts as lesson mathematics it show the tests with "lesson" mathematics</p> <p>i want to display for example 10 random questions with their answers. note that each questions has plurality of different answers. e.g. question 1 have 3 different answers. question 2, 5 different answers. </p> <p>i made an effort to catch the data related with the quiz_id but this method is wrong. im new in php, mysql. </p> <pre><code>&lt;?php include('../connect_db.php'); $sql = "select * from multiple_choice_questions inner join multiple_choice_answers on (multiple_choice_questions.quiz_id = multiple_choice_answers.quiz_id) inner join multiple_choice_info on (multiple_choice_questions.quiz_id = multiple_choice_info.quiz_id)"; $myData3 = mysql_query($sql); while($row = mysql_fetch_array($myData3)) { echo '&lt;input type="text" value="'.$row['question'].'" name="q'.$row['quiz_id'].'"/&gt;&lt;br&gt;'; echo '&lt;input type="radio" value="'.$row['answer'].'" name="q'.$row['answer'].'"/&gt;"'.$row['answer'].'"'; } ?&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMitel Castro
    1. USMitel Castro
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POshow multiple choice questions with answers to user
      1. This table or related slice is empty.
      1. VTDownMod
    1. COWhy have you got `quiz_id` on your questionaire table? Isn't `quiz_id` a question ID? In that case it would be 1:1 relationship of question:questionaire.
      singulars
      1. POshow multiple choice questions with answers to user
      1. USMrCode
    2. COto enable a teacher to puts as many answers he wants
      singulars
      1. POshow multiple choice questions with answers to user
      1. USMitel Castro
    3. COSo you are duplicating the questionnaire row for every question that is applied to it? The db structure doesn't seem right. It would be better with an info_id in the question table, so that questions can relate to a questionnaire, and you can have many questions to one questionnaire.
      singulars
      1. POshow multiple choice questions with answers to user
      1. USMrCode
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload