Checkboxes update

thoand

In my application I store values from checkboxes, this is okay
But my problem is on the update page of the application.

The checkbox values is generated from another database table,
and gets printed during a loop.

[] Me [] You [] Others

I have another table that stores the id for the page that is getting updated and which roles for this page

How can I print the checkboxes so that the ones that are checked during the insert is cheked when printed on the update page.

Hope this was not difficult to understan
late now 🙂

best regards Thomas A.

evo4ever

Go here: http://phpevo.com/custom.php and look at the way the script works. Is that what u want but with checkboxes?

thoand

Yes i have a CMS where pages can have user access based on what role

when I want to update a page
I go to the update page,
get my roles as a result from the roles table

loop
print them out in a checkobx
/loop

I tried to do a loop inside the roles loop, but it prints out the roles twice, but do the selected right
here is 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) {
		//check the boxes that is checked
		echo "<input type=\"checkbox\" value=\"".$getRoles->urid."\" name=\"insertIntoPageAccess[]\" id=\"other\" onClick=\"JavaScript:uncheckAll();\" CHECKED> ".$getRoles->role."&nbsp;&nbsp;\n";
	}
	else {
		echo "<input type=\"checkbox\" value=\"".$getRoles->urid."\" name=\"insertIntoPageAccess[]\" id=\"other\" onClick=\"JavaScript:uncheckAll();\"> ".$getRoles->role."&nbsp;&nbsp;\n";
	}

}

}
?>

a bit object oriented here though.