Ok here is the scenario. There will be "Items" that are of a "Type" and each "Type" has it own "Questions" and the "Questions" have their own "Answers". So how do I store the "Answers" chosen for each "Question" for each "Item".
The table structure so far is below. Let me know if this doesn't make sense, or if I am going about this wrong. Thanks, Joey CREATE TABLE `items` ( `id` int(11) NOT NULL auto_increment, `type_id` int(11) NOT NULL, `title` varchar(255) default NULL, `description` mediumtext, `date` datetime NOT NULL, PRIMARY KEY (`id`), KEY `type_id` (`type_id`) ) CREATE TABLE `types` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE `questions` ( `id` int(11) NOT NULL auto_increment, `question` mediumtext NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE `answers` ( `id` int(11) NOT NULL auto_increment, `answer` mediumtext NOT NULL, PRIMARY KEY (`id`) ) CREATE TABLE `answers_questions` ( `answer_id` int(11) NOT NULL, `question_id` int(11) NOT NULL, `order` int(11) default NULL, PRIMARY KEY (`answer_id`,`question_id`) ) CREATE TABLE `questions_types` ( `question_id` int(11) NOT NULL, `type_id` int(11) NOT NULL, `order` int(11) default NULL, PRIMARY KEY (`question_id`,`type_id`) ) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
