---------------------------------------------- TO CREATE A SURVEY ---------------------------------------------- Create a new survey: --> INSERT INTO `surveys` (`title` ) VALUES ('How old are you ?'); Get the ID of the survey just created: --> surveyID = Select LAST_INSERT_ID(); Add the option 'Rock' which is number selectionNumber, to this survey: --> INSERT INTO `survey_options` (`survey_id`, `selection_number`, `text`) VALUES("+surveyID+", "+selectionNumber+", 'Rock'); To modify an option: --> UPDATE `survey_options` SET `text` = 'Pop/Rock' WHERE `survey__id` ="+surveyID+" AND `selection_number`=1; Add the second option of this survey: --> INSERT INTO `survey_options` (`survey_id`, `selection_number`, `text`) VALUES("+surveyID+", 2, 'Jazz'); ... etc ----------------------------------------------- DEFINE THE DEFAULT SURVEY ----------------------------------------------- Determine if there is already a default survey: (if the number returned is greater than 0, there is already a defalu survey) --> SELECT count(*) FROM `activations` WHERE `activations`.`type` = 'survey' AND `activations`.`desactivation_date` = NULL AND `activations`.`activation_date` = NULL; Insert a new default survey: --> INSERT INTO `activations` (`type`, `type_id`) VALUES ('survey', 1); Modify the default survey (change ID 1 to 2): --> UPDATE `activations` SET `type_id` =2 WHERE `activation_date` = NULL AND `desactivation_date` = NULL LIMIT 1;