| <%if($var_idioma=='_IA'){echo "Encuesta";}else{echo "Survey";}%> |
<%
$sql="select pregID,pregTexto,pregTexto_IA
from encPreguntas
where encID='$encID' and
pregActiva='S'
order by pregTexto";
$rspreg=$conn->execute($sql);
if(!$rspreg){
echo "Ha ocurrido un error XG10203
";
die();
}
$aux1=1;
while(!$rspreg->eof){
$pregID=$rspreg->field("pregID");
$pregTexto=campo_ia2("rspreg","pregTexto",0);
%>
|
| <%=$pregTexto%> |
|
<%
$sql="select sum(resHits)
from encRespuestas
where pregID='$pregID'";
$rssum=$conn->execute($sql);
$suma=$rssum->field("sum(resHits)");
if(!$rssum){
echo "Ha ocurrido un error XG10202
";
die();
}
$sql="select resID,resHits,resTexto,resTexto_IA
from encRespuestas
where pregID='$pregID'
order by resID";
$rsres=$conn->execute($sql);
if(!$rsres){
echo "Ha ocurrido un error XG10203
";
die();
}
$aux2="a";
while(!$rsres->eof){
/*Cálculo del porcentaje*/
if($suma!=0){
$porcent1=number_format(100*$rsres->field("resHits")/$suma,1,",",".");
$porcent2=number_format(320*$rsres->field("resHits")/$suma,0,",",".");
$porcent3=320-$porcent2;//320=340(tabla)-20(td)
} else {
$porcent1=number_format(0,1,",",".");
$porcent2=0;
$porcent3=320-$porcent2;
}
%>
|
| <%=$aux2%>) |
<%=$porcent1%>% <%=campo_ia2("rsres","resTexto",0)%> (<%=$rsres->field("resHits")%>) |
|
|
|
|
|
<%$rsres->movenext();$aux2++;}%>
| |
<%$rspreg->movenext();$aux1++;}%>
| 100% Total <%=$suma%> <%if($var_idioma=='_IA'){echo "votos";}else{echo "votes";}%> |
| |
| <%if($var_idioma=='_IA'){echo "CERRAR";}else{echo "CLOSE";}%> |
|