=CURDATE() order by id desc";
$dbc = mysql_query($query);
//check widget
if(isset($_GET["quizid"])){
$_GET["quizid"]=cleanup($_GET["quizid"]);
$qy = "select * from quizes where id=".$_GET["quizid"];
$resource = mysql_query($qy);
$rw=@mysql_fetch_assoc($resource);
$q2= "select * from quizes where start<=CURDATE() and end>=CURDATE() order by id desc";
$res2 = mysql_query($q2);
$row1 = @mysql_fetch_array($res2);
//var_dump($rw);
$quiz_id = $rw["id"];
if(isset($_COOKIE["quiz"][$quiz_id]) and $_COOKIE["quiz"][$quiz_id]==$quiz_id){
//grafic
$graficsondaj="";
//constructie grafic sondaj
$graficq1="select count(*) as count, `vote` from `qvotes` where `quiz_id`=$quiz_id group by `vote`";
$resg=@mysql_query($graficq1);
while($resultgraf = @mysql_fetch_assoc($resg)){$graf[]=$resultgraf;}
//var_dump($graf);
$total=0;
foreach($graf as $vot){$total+=$vot["count"];}
foreach($graf as $vot){
$newkey=$vot["vote"];
$procente[$newkey]=round($vot["count"]/$total,2)*100;
}
$data=base64_encode(json_encode($procente));
//var_dump($row1);
for($j=1;$j<5;$j++){
$keyname="answer".$j;
if($row1[$keyname]!=""){$answ[]=$row1[$keyname];}
}
//var_dump($answ);
$raspunsuri="";
$intrebare=$row1["question"];
foreach($answ as $answer){
//$answer=textTruncate($answer,50);
$raspunsuri.="$answer";
}
$raspunsuri="$raspunsuri
";
$intrebare="$intrebare
";
$graficsondaj="$intrebare
![](\"/quiz/chart.php?data=$data\")
$raspunsuri
$raspunsuri
";
$intrebare="$intrebare
";
$graficsondaj="$intrebare
$raspunsuri
intrebarea $intrebare:
$procent%
";
}
$data=base64_encode(json_encode($procente));
//var_dump($row);
for($j=1;$j<5;$j++){
$keyname="answer".$j;
if($row[$keyname]!=""){$answ[]=$row[$keyname];}
}
//var_dump($answ);
$raspunsuri="";
$intrebare=$row["question"];
foreach($answ as $answer){
$answer=textTruncate($answer,50);
$raspunsuri.="$answer";
}
$raspunsuri="$raspunsuri
";
$intrebare="$intrebare
";
$graficsondaj="$intrebare
$raspunsuri