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;
}
