php coding help

[emma_ratm]

hello everyone,

im a newbie here and would like to ask around a few questions that might confuse everyone about my data. i am new with php as well as mysql. im developing a system which collects the data from course evaluation submitted by students in my faculty.

 

supposed that i have a table which collects data from students where the columns are as follows:

 

table name: student_evaluation

StudentEvalID (PK,auto_increment)

EvaluationID (PK for evaluation taken from the evaluation table) -

StudentID (PK for student who should take the particular evaluation from student table)

Question1 (Question no 1 which stores the answer for Question 1)

.. (ques2)

..(ques3)

..

..

..

Question17 (Question no 17 which stores the answer for question 17)

Done (The default value is 'No' but if the student submit the evaluation and answer all questions, then the value will be changed to 'Yes')

 

the data looks like this:

StudEvalID     EvaluationID     StudentID     Question1    Question2  ......   Question17    Done

 1                       7                  2                1                 2                        2            Yes

 2                       7                  3                2                 4                        4            Yes

3                        7                 15               6                  3                       3            Yes

4                       8                  2                  5                4                       4             Yes

5                        8                  12                2                 2                        2            Yes

 

The questions are answered according to scale given: if they choose radiobutton1, then the value stored will be 1, radiobutton2 the value will be 2 and same goes to other questions.

 

the question is........

how do i create another table that has the information of the EvaluationID, but has other info which is Question1 how many answered 1 and how many answered 2, Question2 how many answered for 2, Question17 how many answered 5 and so on.

 

this is quite tough to be understood but i hope someone would really like to help me here  

 

thank you in advance and i hope to obtain answers.