Checkboxes?

[Anon]

I don't quite understand how to process forms with PHP.
I have a site with a memberlist, and for each member there is a checkbox.

<input type=\"checkbox\" name=\"admin[$username]\">

if checked, when I click submit, the following query should be executed:

mysql_query("UPDATE tq_users SET admin='1' WHERE id='$id'") or die ("Error:".mysql_error());

this is what I tried using:

do {
if ($admin[$username] == "checked") {
mysql_query("UPDATE tq_users SET admin='1' WHERE id='$id'") or die ("Error:".mysql_error());
}
echo "Updated";
} while ($myrow = mysql_fetch_array($result));

but I get this error:
Warning: Undefined index: in Admin/Users.php on line 77

line 77 is :
if ($admin[$username] == "checked") {

[Anon]

I tried changing my code, but still no luck. this is what I have now.

	if ($myrow["admin"] == "1") {
		$admin_box = "<input type=\"checkbox\" name=\"admin\" value=\"$username\" checked>";
	} else {
		$admin_box = "<input type=\"checkbox\" name=\"admin\" value=\"$username\">";
	}

---

do {
if ($admin == "checked") {
mysql_query("UPDATE tq_users SET admin='1' WHERE username='$username'") or die ("Error:".mysql_error());
}
echo "Updated record for <strong>$username</strong><br>";
} while ($myrow = mysql_fetch_array($result));

[Anon]

I think u need to try another approach to this problem. When u are comparing your checkbox to the value "checked", it's actually looking at the value of your checkbox to see if it matches the string "checked" when in actuallity, the value is whatever u have there...$username. I'm having the same problems with that right now. Trying to figure out how to get around it.

Post if u find out anything ..i'm curious hehe.
Byes.