Checkbox Assignment
Posted: Wed Sep 12, 2007 12:30 pm
I have a list of checkboxes like below:
When the form is submitted I then run this code:
Right now that code only will se corporate='$whatever' when boxes are selected. I also want it to set corporate='' if a box is unselected and then submitted.
Code: Select all
$username = $row["username"];
$result = mysql_query("SELECT * FROM users WHERE account_type='1' ORDER BY username ASC");
while($row = mysql_fetch_array($result)) {
$result1 = mysql_query("SELECT * FROM users WHERE username='$username'");
$row1 = mysql_fetch_array($result1);
if($row["corporate"] == $row1["username"]) {
$checked = " checked";
} else {
$checked = "";
}
echo "<input type=\"checkbox\" name=\"userID[" . $row["id"] . "]\"$checked>" . $row["username"] . "<br>\n";
}Code: Select all
foreach($_POST["userID"] as $userID => $check) {
mysql_query("UPDATE users SET corporate='$username' WHERE id='$userID'");
}