test";
$sql = "SELECT sys_language_uid as l, `answers` FROM `tx_pbsurvey_item` WHERE hidden=0 AND pid=408";
$res = mysql(TYPO3_db, $sql);
$answer = array();
while($resRow = mysql_fetch_assoc($res)) {
$delimiter = ($resRow['l']==2) ? "||" : "|";
$answer[$resRow['l']] = explode($delimiter, $resRow['answers']);
}
// set answer in correct language if available
$answerL = isset($answer[$L]) ? $answer[$L] : $answer[0];
// get all answers
$sql = "SELECT count(*) FROM `tx_pbsurvey_answers`";
$answer_tot = mysql_result( mysql(TYPO3_db, $sql), 0);
// get answers
$sql = "SELECT `answer` as i, count(*) as no FROM `tx_pbsurvey_answers` GROUP BY `answer`";
$res = mysql(TYPO3_db, $sql);
$output .= '';
while($resRow = mysql_fetch_assoc($res)) {
$text = $answerL[$resRow['i'] - 1];
$value = $resRow['no'];
$percent = (int)($value / $answer_tot * 100);
$output .= theme_element($text, $value, $percent);
}
$output .= '
';
print $output;
function theme_element($text, $value, $percent) {
$output = '';
$output .= '' . $text . '';
$output .= '' . $value . '';
$output .= '(' . $percent . '%)';
$output .= '';
return $output;
}
?>