Ik zit met een query die niks return't.
De query zit op lijn 11 en volgens mij is hij goed opgesteld.
<?php
if($pollQuery = mysql_query("SELECT vraag, id FROM cms_poll WHERE active = '1' LIMIT 1") === FALSE)
{
$error->showError("Een database fout:<br/>".mysql_error()."<br/>De poll kan niet (goed) geladen worden.");
}
$pollFetch = mysql_fetch_assoc($pollQuery);
?>
<div id="pollquestion_12"><strong><?php echo $pollFetch['vraag']; ?></strong></div>
<div id="pollwrapper_12">
<?php
if($answareQuery = mysql_query("SELECT ans.answare as answare, COUNT(vote.id) as check FROM cms_poll_answare ans, cms_poll_votes vote WHERE vote.poll_id = '".$pollFetch['id']."' AND ans.poll_id = '".$pollFetch['id']."'") === FALSE)
{
$error->showError("Een database fout:<br/>".mysql_error());
}else{
while($answareFetch = mysql_fetch_assoc($answareQuery))
{
if($answareFetch['check'] > 0)
{
echo'<div id="answer_12">
<div id="answer12_text">'.$answareFetch['answare'].' </div>
</div>';
}else{
echo'<div id="answer_12">
<input type="radio" onclick="this.form.submit()" name="vote" value="votes4">
'.$answareFetch['answare'].'
</div> ';
}
}
}
?>
Iemand weet wat er fout is?
Bedankt!
Wouter