public function Answers($memberID = 0)
{
$memberID = DB::Safe($memberID);
$q = "SELECT ID FROM SurveyAnswers WHERE QuestionID='{$this->ID}'";
if ($memberID > 0) {
$q .= " AND MemberID='{$memberID}'";
}
$r = DB::Run($q);
$ans = array();
while ($answerID = mysql_fetch_array($r)) {
array_push($ans, SurveyAnswer::Load($answerID['ID']));
}
// When getting a specific members' answers, only return the
// single answer if there is just one. Much easier to work with.
if (mysql_num_rows($r) == 1 && $memberID > 0) {
return $ans[0];
} elseif (mysql_num_rows($r) == 0 && $memberID > 0) {
return null;
} else {
return $ans;
}
}
