[RESOLVED] use form result to display a database entry

woodplease

i have a form which displays questions and answers from a database. each answer has a radio button next to it with a particular value. what i want to do is somehow calculate the total from all the radio buttons selected, and then display a comment from a database table according to what the total is. e.g, if they get between 25% and 50%, it will display "not very good etc. Any ideas on how i could do this?

bradgrafelman

What do you mean "calculate the total" - are you adding something together, or is there a correct response for every question and you're trying to calculate their percent based on correct answers?

woodplease

each answer has a particular value assigned to it, so i would need to calculate the total of all the answers, and then workout a percentage., then using that percentage to decide what entry from another table would be displayed

bradgrafelman

Okay, summing all of the values is easy enough, but what would the sum be divided by to form the percentage?

woodplease

well that is one of the problems, because the user can add as many questions as he or she likes. there are only 4 answers per question though, each with a different value between 1 and 4.

djjjozsi

Its a very simple one, but might be useful for you.
radio button make

woodplease

this is similar to what i would need, but how would i get it to display an entry from a database, depending on what the total is?

djjjozsi

woodplease;10940965 wrote:
this is similar to what i would need, but how would i get it to display an entry from a database, depending on what the total is?

You have to calculate the percentage from the total and the sum()-ed values, call it $percentage.

And create an SQL query:

$sql="select messsage from definition WHERE $percentage BETWEEN start AND to";

woodplease

djjjozsi;10940995 wrote:
You have to calculate the percentage from the total and the sum()-ed values, call it $percentage.

And create an SQL query:
$sql="select messsage from definition WHERE $percentage BETWEEN start AND to";

ok, but how would i find out what radio buttons have been selected?

paulnaj

Oh-oh double post - just answered this question elsewhere

http://www.phpbuilder.com/board/showthread.php?t=10371032