[Resolved] Checkboxes

[smsharif]

I am trying to create a form that will accept input from the user, to select certain checkboxes. After this record has been updated the form should display the checkboxes based on the data stored in the database.

How can this be done.

[devinemke]

what is the data structure? (table names, fileld names, field types)?

[terfle]

this should get you started...

<?
$result = mysql_query("SELECT name,value,title FROM LOOKUPTABLE");
while ($row = mysql_fetch_array($result)) {
	unset ($checked);
	// enduserform stores all of the user's information
	$result_enduserform = mysql_query("SELECT isChecked FROM enduserform WHERE name = '$row[name]' AND enduser_id = '$enduser_id'");
	$row_enduserform = mysql_fetch_array($result_enduserform); 
	if ($row_enduserform['isChecked'] == "checked")
		$checked = "CHECKED";
	echo "<div>$row[title] <input type=checkbox name='$row[name]' value='$row[value]' $checked></div>";
}
?>