I am having a little trouble updateing my mysql table with a bunch of checkboxes. Basically I call the database and return a list of usernames and there "active" status.
If user is active it returns a 1 else 0. I have it so it prints one checkbox with the user's id_number and the value is 1 or 0. How do I udate the mysql table with one submit and loop through all of the checkboxes
i.e.-
| 1 | Brian Sampson
| 0 | Chad Cannuck
| 1 | Mike Roch
| 1 | Sam Tatum
If the administrator unchecks brian sampson then the mysql table much update the value to zero and check through the rest of the values to see if they have changed.
