Enquete

"; while($answerrow = mysql_fetch_array($answerquery)) { $answerid = $answerrow['id']; $radiob = (""; } else { $radiob = $radiob. ">"; } echo $radiob; echo $answerrow['resposta']."
"; $counter++; } if ($num_answers > 0) { echo "

"; } } function calcularvoto($enquete, $opcao, $pollip) { $ipquery = mysql_query("SELECT * FROM sys_enquetes_perg WHERE id='$enquete' AND ultimoip='$pollip'"); $checkrows = mysql_num_rows($ipquery); if($checkrows==0) { $voted='no'; } else { $voted='yes'; } if($voted=='no') { $updateip = mysql_query("UPDATE sys_enquetes_perg SET ultimoip='$pollip' WHERE id='$enquete'"); $answerquery = mysql_query("SELECT * FROM sys_enquetes_resp WHERE id='$opcao'"); while($answerrow = mysql_fetch_array($answerquery)) { $newvote = $answerrow['votos']+1; } $changesindb = mysql_query("UPDATE sys_enquetes_resp SET votos='$newvote' WHERE id='$opcao'"); $answerquery = mysql_query("SELECT * FROM sys_enquetes_resp WHERE enquete_id=$enquete"); $num_answers = mysql_num_rows($answerquery); $total=0; while($answerrow = mysql_fetch_array($answerquery)) { $answer[] = $answerrow['pergunta']; $votes[] = $answerrow['votos']; $id[] = $answerrow['id']; } for($counter=0;$counter<$num_answers;$counter++) { $total=$total+$votes[$counter]; } for($counter=0;$counter<$num_answers;$counter++) { if($votes[$counter]!=0) { $votecalc[] = 100/$total*$votes[$counter]; if($votecalc[$counter]>=10) {$votetotal = substr($votecalc[$counter],0,2);} if($votecalc[$counter]==100) {$votetotal = substr($votecalc[$counter],0,3);} if($votecalc[$counter]<10) {$votetotal = substr($votecalc[$counter],0,1);} if($votecalc[$counter]==0) {$votetotal=0;} } else { $votecalc[] = 0; $votetotal=0; } $theid = $id[$counter]; $calc = $votecalc[$counter]; $changesindb = mysql_query("UPDATE sys_enquetes_resp SET resultado='$calc' WHERE id='$theid'"); } } else { echo "Voc� j� votou uma vez!
"; } } function resultados($enquete,$pergunta,$nvotos) { $resultquery = mysql_query("SELECT * FROM sys_enquetes_resp WHERE enquete_id=$enquete ORDER BY id DESC"); while($resultrow = mysql_fetch_array($resultquery)) { echo "".$resultrow['resposta']." | "; echo $resultrow['resultado']."%"; if($nvotos == "s"){ echo " (".$resultrow['votos']." votos)"; } echo "
"; if($resultrow['resultado']>0) { $tamanho = $resultrow['resultado'] * 2; echo "

"; } } } ?>