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