0 &&!in_array($surveyid, $tmp)){
setcookie('survey',$_COOKIE['survey'].';'.$surveyid, time() +(365 * 24 * 3600));
$res = mysqlquery('SELECT id FROM surveydata WHERE ddate>=NOW() - INTERVAL 2 DAY AND ip=\''.$_SERVER['REMOTE_ADDR'].'\'');
if(mysql_num_rows($res) < 100){
$sql = "INSERT INTO surveydata(answer_id,ip,ddate) VALUES($answer, '".$_SERVER['REMOTE_ADDR']."',NOW())";
mysqlquery($sql);
}
}
}
$sql = "SELECT id, title,txt FROM survey WHERE deleted=0 AND id=".intval($surveyid);
$res = mysqlquery($sql);
$PAGEINFO = array();
if(mysql_num_rows($res))
$PAGEINFO = mysql_fetch_array($res, MYSQL_ASSOC);
$PAGETITLE = $PAGEINFO['title'];
include 'header.php';
echo $PAGEINFO['txt'].'
';
$sql = "SELECT
sa.id,
sa.txt,
COUNT(sd.answer_id) AS votes
FROM
surveyanswers AS sa
LEFT JOIN
surveydata AS sd
ON
sd.answer_id=sa.id
WHERE
sa.survey_id=".intval($surveyid).'
GROUP BY
sa.id
ORDER BY
votes DESC';
$res = mysqlquery($sql);
$bigest = 0;
$answers = array();
$allVotes = 0;
while($row = mysql_fetch_array($res, MYSQL_ASSOC)){
$answers[] = $row;
if($row['votes'] > $bigest)
$bigest = $row['votes'];
$allVotes += intval($row['votes']);
}
$unit = 0;
if($bigest)
$unit = (200 / $bigest);
//echo "";
echo '';
foreach($answers as $v){
$percent = 0;
if($allVotes)
$percent = (($v['votes'] / $allVotes)*100);
?>
| : |
 0 % |
';
$HIDETOP = true;
include 'footer.php';
?>