Questionnaire Help

Blaze___

Hi again guys! I have made a questionnaire and I want to make a php file which it will summarize and display
the answers of all who have answered with percentages.
For instance if the questionnaire has 2 questions and every question 3 options then the file must display
Question1:
option A 20%
option B 25%
option C 55%
Question2:
option A 20%
option B 20%
option C 60%
How could i make this file?Plz help me.Thanks a lot.

itaym02

How do you keep the info about each question?

Say each question is a structure of question + array of answers.
For each answer you will keep the number of people who selected that answer.
With that info you can calculate by hand the percentage for each question.
If until now all is clear, I will help you further to make it a program.

regards

Blaze___

I have made a db which contains 4 tables.
one table where i keep name surname nad registry number and 3 where i insert the answers of every question.
Though the structure of every question is as you have mentioned before.
But I don't know how to keep the number of the people who select every answer.
If you tell what to do I would be greatful.thanks

itaym02

If I understand your db structure.

For each question table, you should have entry for answer.
Each answer will be filled there.

table: question 1

row:answers (you have three answers)
1
1
3
2
2
3
3
2
1

So all you have to do is count how many times each answer was given for an answer.

Blaze___

No,i have made a questionnare which is divided in 3 pages.
Each page "post" its answers to a current table,which means i have one table
for every page.
Sorry for the misunderstanding it was my mistake🙂.

itaym02

Let me see,

Each page asks one question?

And you have one table per page - table per question.

Did I get it right?

Blaze___

Every page contains more than one question.For instance my first page ask 16
questions,my second 13 questions and my third 18.
But it is true that i have a table per page.

itaym02

What is the structure of the table/s?
it might be you'll have to change your db structure, but we will be wiser after seeing it.