mysqlifejl: Commands out of sync; you can't run this command now
Jeg er blevet blind på denne fejl. Kan nogen hjælpe?Fejlen kommer på linjen:
$hentundergrupper->bind_param('i',$hu_id);
-----------------------------
<?php
//hent varekategorierne
if($hentvaregrupper = $mysqli->prepare('SELECT id, label FROM tblstruktur WHERE relation = 0 AND visibility = 1 ORDER BY hsort ASC')) {
$hentvaregrupper->execute();
$hentvaregrupper->bind_result($hv_id,$hv_label);
} else {
echo($mysqli->error);
}
//hent underkategorierne
if($hentundergrupper = $mysqli->prepare('SELECT id, label FROM tblstruktur WHERE relation = ? AND visibility = 1 ORDER BY label ASC')) {
} else {
echo($mysqli->error);
}
?>
<nav>
<ul class="col-3 padnul" >
<?php while($hentvaregrupper->fetch()) { ?>
<li>
<a href="#<?php echo$hv_id; ?>" class="menu" ><?php echo(ucfirst($hv_label)); ?></a>
<ul class="col-3 padnul" >
<?php
$hentundergrupper->bind_param('i',$hu_id);
$hu_id = $hv_id;
$hentundergrupper->execute();
$hentundergrupper->bind_result($rel_id,$rel_label);
while($hentundergrupper->fetch()) { ?>
<li><a href="#<?php echo$rel_id; ?>" class="menu" ><?php echo(ucfirst($rel_label)); ?></a></li>
<?php } ?>
</ul>
</li>
<?php } ?>
</ul>
<?php
$hentvaregrupper->close();
$hentundergrupper->close();
?>
<div class="col-6" ></div>
<div class="col-3" ></div>
</nav>