help needed with form and mysql design.

Hi, I'm having trouble designing a good html-form/MySQL combination for an access rights system. I'm having three tables in MySQL: members (with member information for my site), albums (with information for separate albums with digital photos on my site) and accessrights (which should function as a "bridge" between members and albums, controling which albums a specific member could view). accessrights is defined by the following: CREATE TABLE accessrights ( albumid INT, userid INT, access ENUM("Y","N") DEFAULT "N" NOT NULL, UNIQUE (albumid, userid) ); albumid is from the albums table, and userid from the members table. For each member/album combination I want accessrights to contain one entry with access set to either Y or N. So far everythings alright. But how do I build a system that lets me control the entries in accessright? Right now, I'm trying with a form for album editing which contains something like this: db_connect($dbuser, $dbpassword, $dbdatabase); $query = "SELECT userid FROM members"; $result = mysql_query($query); while($row = mysql_fetch_array($result)) { echo($row[0]); ?> <INPUT TYPE="checkbox" name="<?php echo($row[0])?>" VALUE="YES"> } This creates a checkbox for every member on my site. But the problem is that only checked boxes are passed on to the next script, which process the form for album-editing. This means that if I uncheck a box that's been checked before, this information isn't passed along. From what I understand, information about unchecked boxes is never passed? Right now, my solution is to first set the field access in the table accessrights to N for every user and then update the table with an Y for those with checked boxes. But how can I limit the MySQL queries to just include members for which the access field has been changed? -- anders thoresson