Jump to content

calculating total based on for loop results


woodplease

Recommended Posts

i'm printing the contents of 2 tables to a page, using for loops. the output are questions and answers. each answer has a value assigned to it. i need to be able to calculate the mark of what the user has when he answers it.  to do this i thought about working out the total number of questions, and multiplying it by 4( as 4 is the higjhest value asigned to a question), but the problem is i dont know how to calculate the number of question that have been echoed. any help would be greatly appreciated

i've posted the code that i use to loop throught the questions and answers

<?PHP

for($i = 1; $i <= $numofrows; $i++) {
$row = pg_fetch_array($result2); //get a row from our result set

echo "
<br/><p>Question ".$row['questionno'].": " .$row['question']."</p>
\n";

$query2 = "SELECT answers.answerno, answers.answer, answers.answervalue, answers.questionno, answers.quizref, answers.answerref 
   WHERE answers.questionno = ".$row['questionno']. " AND answers.quizref = ".$id;




$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

	echo "
	<p>Answer ".$row2['answerno']." : <input type=\"radio\" name=\"" . $row['questionno'] . "\" id=\"selection[]\" value=\"" . $row2['answervalue'] . "\" onclick=\"this.form.total.value=calculateTotal(this);\" >".$row2['answer']."</p>
	\n";

}
}

?>

 

Thanks

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.