online quiz query

[robertson]

Hi, suggestions welcomed

I have an online quiz(zes) to make for a site. The quizzes themselves will not change much I have been throwing around the idea in my head on how to best accomplish this. All questions will be displayed on a single page with a submittal showing number of answers correct, percentage, and answers/explanation.

DB first:
Idea 1:
question table: question_id, question_text, question_answer, question_explanation, question_url
solution table: solution_id, question_id, solution_text

Idea 2:
question table: question_id, question_text, question_answer, question_explanation, question_url, question_solution1, question_solution2, question_solution3, question_solution4

The most a question can have is four answers (maybe change in the future) but some only have two; this leads to me preferring Idea 1.

Now the question is, what is the best way to get this information out of th -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[snorter]

first you should use your first idea

to pull the data out you'll be wanting to use a bit of code like

PHP Code:
$sql = "SELECT * FROM question";
$result = mysql_connect("localhost", $sql);
$row = mysql_fetch_assoc($result);



that way you can pull question data by calling on the variable $row['name of row here'];

then to pull from the solution table use

PHP Code:
$question_id = $row['question_id'];
$sql2 = "SELECT * FROM solution WHERE question_id = '$question_id'";
$result2 = mysql_connect("localhost", $sql2);
$row2 = mysql_fetch_assoc($result2);


and then display the data from there with $row2['enter row name here']; -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --