I've just done a survey. I had: Surveys id,description,intro (an extended text), status (planned,running,finished), date started, date finished Questions id,survey_id,question,sequence Answers id,question_id,answer,sequence Responses id,survey_id,email_address Response_answers, id,question_id,answer_id
Are you interested in getting the code? I'm trying to tidy it to release. On 06/02/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Please help me if possible. Trying to do a simple Survey. Survey has > 10 Questions, each question has one of 4 possible Answers. I'm trying > to get the data model correct. > > surveys table has id, survey_name, date_created > questions table has id, question > surveys_questions has survey_id,question_id,answer > > does this sound correct? How do I set the form field names to make it > simple to save the data? I'm using radio buttons,one per question, > right now. > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---