I want to write a poll script based on certain candidates.
My table structure is as follow:
Answers - id, answer, candidate_id, question_id
Questions - id, question
Candidates - id, names
Each candidate will have the question and the answer. For example, I have 10 questions. Each candidate will have 10 questions and each question will have answer to it of the candidate.
What I don't know is how will I link the table. For example, I have created a candidate, I want the newly created candidate to have all the questions linked to him from questions and answers page and vice versa.
Any idea guys?
P.S: I'm a newcomer to programming.