Karlaugustsson90 Posted February 3, 2011 Share Posted February 3, 2011 hello everyone im reativlivly new to php and mysql and i am in desperate need of any kind of help right now. i am building a quiz with multiple answers, and i have spent sleepless nights trying to figure out how to display my mysql data in php. i want all my questions with their answers to displayed something like: Name of quiz question 1 ___________ answer a [] | picture | answer b [] answer c [] | | ____________ question 2 ___________ answer a [] | picture | answer b [] answer c [] | | ____________ question 3 ___________ answer a [] | picture | answer b [] answer c [] | | ____________ :Submit: Here are dumps from my database Dumping data for table quiz quiz_id quiz_name datecreated pdf 32 multiplikation 2011-02-02 19:07:29 multiplikation Dumping data for table question quiz_id questionary question_id img 32 vad blir fem plus 7 2 vad_blir_fem_plus_7 32 vad blir 4 gånger 7 31 vad_blir_4_gånger_7 Dumping data for table answer answer_id quiz_id question_id answerr truefalse 117 32 2 12 1 118 32 2 13 0 119 32 2 67 0 120 32 2 77 0 121 32 31 76 1 122 32 31 55 0 123 32 31 28 0 124 32 31 44 0 As you can see each table share the same quiz_id, the answer table gets the question_id from the table question. and here is my php code (please take note that i'm a newbie in both php and mysql) <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <?php require_once ("include/connect.php"); ?> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <link href="style.css" rel="stylesheet" type="text/css" /> </head> <body> <div class="box"> <div class="box2">bajs</div> <div class="box3"> <?php $get=$_POST['quiz']; //visa quizens namn $query2="SELECT * FROM quiz WHERE quiz.quiz_id=$get"; $result2= mysql_query($query2)or die (mysql_error()); //RUN THROUGH while($row2=mysql_fetch_array($result2)){ echo"<p>"; echo $row2['quiz_name']; echo"</p>"; } ?> <?php //visa quizens namn $query3="SELECT * FROM question,answer WHERE question.quiz_id=$get AND question.question_id=answer.question_id GROUP BY answer.question_id"; $result3= mysql_query($query3)or die (mysql_error()); //RUN THROUGH while($row3=mysql_fetch_array($result3)){ echo"<p>"; echo $row3['questionary']; echo"</p>"; echo"<p>"; echo $row3['answerr']; echo"</p>"; } ?> </div> </div> </body> </html> Link to comment https://forums.phpfreaks.com/topic/226562-help-with-php-quiz/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.