Hi, I am trying to tick my dynamicly generated checkboxes,
the ticking goes okay but each roles gets printed twice
can anyone help
the code:
<?
$getRoles = $db->get_results("SELECT * FROM userroles ORDER BY role");
foreach ($getRoles as $getRoles) {
$getSelected = $db->get_results("SELECT pageid, prole FROM pageaccess WHERE pageid = ".$pages->pid."");
foreach ($getSelected as $getSelected) {
if ($getSelected->prole == $getRoles->urid) {
echo "<input type=\"checkbox\" value=\"".$getRoles->urid."\" name=\"insertIntoPageAccess[]\" id=\"other\" onClick=\"JavaScript:uncheckAll();\"> ".$getRoles->role." \n";
}
else {
echo "<input type=\"checkbox\" value=\"".$getRoles->urid."\" name=\"insertIntoPageAccess[]\" id=\"other\" onClick=\"JavaScript:uncheckAll();\"> ".$getRoles->role." \n";
}
}
}
?>
regards Thomas A.