//$check = "SELECT * FROM results WHERE study_id = ".$study_id." AND subj_id = ".$subject_id." AND question_id = ".$question_id;
//$result = mysql_query($check, $dbconnect);
// if(mysql_num_rows($result) == 0){
$questionnaire_id = get_questionnaire_for_question($question_id);
$data['subj_id'] = $subject_id;
$data['response_id'] = $response_id;
$data['study_id'] = $study_id;
$data['questionnaire_id'] = $questionnaire_id;
$data['question_id'] = $question_id;
$data['question_name'] = get_question_name($question_id, 'ro');
$data['question_type'] = $question_type;
$data['choice_id'] = null;
$data['score'] = null;
$data['data'] = null;
if ($question_type == 'choice') {
$choice_name = get_choice_name($answer, 'ro');
$query = "INSERT INTO results (`study_id`, `subj_id`, `questionnaire_id`, `question_id`, `choice_id`, `data`, `response_id`)\n\t\t\t\t\tVALUES ('" . $study_id . "', '" . $subject_id . "', '" . $questionnaire_id . "', '" . $question_id . "', '" . $answer . "', '" . $choice_name . "' , '" . $response_id . "') ";
$result = mysql_query($query, $dbconnect);
confirm_query($result);
$data['choice_id'] = $answer;
$data['score'] = get_choice_score($answer);
} elseif ($question_type == 'text') {
$query = "INSERT INTO results (`study_id`, `subj_id`, `questionnaire_id`, `question_id`, `data`, `response_id`)\n\t\t\t\t\t\t\t\t\t\tVALUES ('" . $study_id . "', '" . $subject_id . "', '" . $questionnaire_id . "', '" . $question_id . "', '" . mysql_real_escape_string(htmlspecialchars($answer)) . "', '" . $response_id . "') ";
$result = mysql_query($query, $dbconnect);
confirm_query($result);
$data['data'] = $answer;
}
//}
}
?>
<p><strong>Raspunsurile au fost salvate!</strong></p>
<li class="questionnaire_name">
<?php
echo $questionnaire_name;
?>
</li>
<li class="question_type">
<?php
echo $question_type;
?>
</li>
<li class="answer">
<?php
if ($row['choice_id'] == 0) {
echo $row['data'];
} else {
echo get_choice_name($row['choice_id'], $lang);
}
?>
</li>
<li class="score">
<?php
if ($row['choice_id'] != 0) {
echo get_choice_score($row['choice_id']);
}
?>
</li>
</ul>
</li>
<?php
}
} else {
