Displaying results from 2 Arrays??

[obrienkev]

Hi all,

How do I display results from two arrays??

These are my arrays:

while ($row = mysql_fetch_assoc($result)) 
{	
$questions[$row['question_id']] = $row['text'];
}



while ($row = mysql_fetch_assoc($result)) 
{
// Create array answers where text is associated with question_id
$answers[$row['question_id']] = $row['text'];
}

The question_id field in $answers array is the foreign key of $questions array.

I want to display all the results of $questions array.
But below each result I want to display each result of$answers array.

Make sense?

Basically I want to display questions with their relevant answers below each one.

Thanks.

Kevin.

[eoghain]

Try something like this:

foreach ($questions as $key => $question)
{
   print "$question<br>\n";
   print $answers[$key] . "<br>\n";
}

That should give you each question in the questions array printed out with the corresponding answer from the answers array.

You do know that the way you are building your arrays that you will only have 1 answer per question in your answers array, don't you?

If you want to have more than 1 answer (i.e. a multiple choice quiz) then you need to setup your $answers array to be a multi-dimensional array like so:

while ($row = mysql_fetch_assoc($result)) 
{
// Create array answers where text is associated with question_id
$answers[$row['question_id']][] = $row['text'];
}

foreach ($questions as $key => $question)
{
   print "$question<br>\n";

   foreach ($answers[$key] as $answer)
   {
      print "$answer<br>\n";
   }
}

[Cailean]

any particular reason why the questions and answers aren't in the same table/array?

It would then be a simple case of stepping through and echoing:
$q_a[$row[question_id]][question] and $q_a[$row[question_id]][answer].

Check out php's various array functions... you might be able to create such an array that would be easier to work with.