[Resolved] Displaying data 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.

[devinemke]

as i already pointed out in this thread, you have to add another dimension the answers array to effectively relate back to the questions array:

$result = mysql_query('SELECT * FROM questions'); 
while ($row = mysql_fetch_assoc($result)) {$questions[$row['question_id']] = $row['question_text'];} 

$result = mysql_query('SELECT * FROM answers'); 
while ($row = mysql_fetch_assoc($result)) {$answers[$row['question_id']][$row['answer_id']] = $row['answer_text'];}

foreach ($answers as $key => $value)
{
    echo $key . '. ' . $questions[$key] . '<br>';
    foreach ($value as $answer)
    {
        echo $answer . '<br>';
    }
    echo '<br>';
}

[obrienkev]

Thanks mate!!

Figured it at last. With your help of course.

If you get a chance would you mind explaining how the answers array is set up? Trying to get my head around arrays. Thanks again.

Kevin.