Check boxes

[Sharif]

I have a question about checkboxes. Some sites which let you register to be part of their site sometimes have checkboxes to tell them more about you like:

Which Games Do You Own:

• Game 1
• Game 2
• Game 3

And you can check off what you own and click submit. Now I am wondering how that is stored in the database. Is there a field for every single game, or are they stored in one field?

Also, how are you supposed to do a sql query to have the checkboxes that were checked off before be checked off when say a user wants to update the info?

[tekky]

you would need to name each check box sperately and track them seperately unless you want to come up with a method to "code" the results into 1 frield maybe using BITS and also to "decode" the field to reset each field... as far as resetting the fields on form load...

while(list($key, $val) = each($_POST))
{
     echo "<input type='checkbox' name='$key' value='$key'";
     if ($val) { echo "checked"; }
     echo ">$key<br>";
}

this would build a list of checks boxes
with the value as the name of the box, and the caption as the name of the box, and if the value was set... it would reset it as checked

note: you could apply a similiar method to a query it would just be more like

while($row = mysql_fetch_assoc($result))
{
     list($key, val) = $row;
     .....
}