public function getAnswerByQuestion(SxCms_Survey_Question $question) { $db = Zend_Registry::get('db'); $select = $db->select()->from(array('sqa' => 'SurveyQuestionAnswer'), array('*'))->where('sqa.survey_question_id = ?', $question->getId()); $results = $db->fetchAll($select); foreach ($results as $result) { $answer = new SxCms_Survey_Question_Answer(); $answer->setId($result['answer_id'])->setSurveyQuestionId($result['survey_question_id'])->setAnswer($result['answer']); $question->addAnswer($answer, $result['answer_id']); } return; }