woodplease Posted February 1, 2010 Share Posted February 1, 2010 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 Link to comment https://forums.phpfreaks.com/topic/190517-calculating-total-based-on-for-loop-results/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.