[RESOLVED] loops within a loop

[woodplease]

i need help trying to create a loop within a loop. i'm am trying to print out answers to questions. i have the questions in one table, and answers in another. i want it so it looks like:

question 1
answer
answer
answer

question 2
answer
answer
answer

My problem is i dont know where in the first loop, i need to put the code for the second loop

first loop prints out the question

<?PHP

for($i = 0; $i < $numofrows; $i++) {
$row = pg_fetch_array($result2); //get a row from our result set
if($i % 2) { //this means if there is a remainder
echo "<TR bgcolor=\"#666666\">\n";
} else { //if there isn't a remainder we will do the else
echo "<TR bgcolor=\"#777777\">\n";
}
echo "
<p>".$row['questionno']."</p>
<p>".$row['question']."</p>
\n";

?>

second loop prints out the answers to that question

<?PHP

for($i = 0; $i < $numofrows2; $i++) {
$row2 = pg_fetch_array($result3); //get a row from our result set
if($i % 2) { //this means if there is a remainder
echo "<TR bgcolor=\"#666666\">\n";
} else { //if there isn't a remainder we will do the else
echo "<TR bgcolor=\"#777777\">\n";
}
echo "
<p>".$row2['answerno']. "&ndash;".$row2['answer']."</p>
\n";
}
}
?> 

Any help would be great

Thanks

[halojoy]

It looks good.
You can do like you have it.

Only one thing:
you should not use $i for both loops.
The second loop is iinside the first one
and will corrupt the value of $i.

The usual for loop in loop is to use
$i ... for first, outer loop
$j ... for inside loop

<?php

for($i = 0; $i < $numofrows; $i++) {
	$row = pg_fetch_array($result2); //get a row from our result set
	if($i % 2) { //this means if there is a remainder
		echo "<TR bgcolor=\"#666666\">\n";
	} else { //if there isn't a remainder we will do the else
		echo "<TR bgcolor=\"#777777\">\n";
	}
	echo "
	<p>".$row['questionno']."</p>
	<p>".$row['question']."</p>
	\n";

for($j = 0; $j < $numofrows2; $j++) {
	$row2 = pg_fetch_array($result3); //get a row from our result set
	if($j % 2) { //this means if there is a remainder
	echo "<TR bgcolor=\"#666666\">\n";
	} else { //if there isn't a remainder we will do the else
	echo "<TR bgcolor=\"#777777\">\n";
	}
	echo "
	<p>".$row2['answerno']. "&ndash;".$row2['answer']."</p>
	\n";
}
}

[woodplease]

great thanks, that solved it. i've just run into another problem though. i've changed the code so that it prints a radio button with a value, next to each answer. but when it displays, you can only select 1 radio button for all of the questions, instead of 1 radio button per question. any ideas?

<?PHP

for($i = 0; $i < $numofrows; $i++) {
	$row = pg_fetch_array($result2); //get a row from our result set
	if($i % 2) { //this means if there is a remainder
		echo "<TR bgcolor=\"#666666\">\n";
	} else { //if there isn't a remainder we will do the else
		echo "<TR bgcolor=\"#777777\">\n";
	}
	echo "
	<p>".$row['questionno']."</p>
	<p>".$row['question']."</p>
	\n";

$query2 = "SELECT questions.questionno, questions.question, questions.quizref, questions.questionref, answers.answerno, 		answers.answer, answers.answervalue, answers.questionno, answers.quizref, answers.answerref FROM questions JOIN answers ON questions.questionno = answers.questionno WHERE questions.questionno = ".$row['questionno'];


$result3 = pg_query($query2) or die ("Query failed");
//let's get the number of rows in our result so we can use it in a for loop
$numofrows2 = pg_num_rows($result3);

for($j = 0; $j < $numofrows2; $j++) {
	$row2 = pg_fetch_array($result3); //get a row from our result set
	if($j % 2) { //this means if there is a remainder
		echo "<TR bgcolor=\"#666666\">\n";
	} else { //if there isn't a remainder we will do the else
		echo "<TR bgcolor=\"#777777\">\n";
	}
	echo "
	<p><input type=\"radio\" name=\"score[]\" id=\"selection[]\" value=\"" . $row2['answervalue'] . "\" />".$row2['answerno']. "&ndash;".$row2['answer']."</p>
	\n";
}
}

?>

Thanks

[halojoy]

All 3 radiobuttons
for answering a question, should have the same name="xxxxx"
But with 3 different value="answer"

Something like this, where I use $row['questionno'] for refering to question.

echo "
		<p><input type=\"radio\" name=\"'. score[$row['questionno']] ."\" id=\"selection[]\" value=\"" . $row2['answervalue'] . "\" />".$row2['answerno']. "&ndash;".$row2['answer']."</p>
		\n";

[woodplease]

thanks very much, i dont know why i didnt think of that myself.