retrieve multiple check box

[CrOuZ]

Hi,
I retrieve my sql data to multiple select box for user profile update page.

$colors = array("black", "Green", "blue");

$dbcolors= explode(',' ,$row['color']);

  foreach ($colors as $color) {

 if(in_array($color,$dbcolors)) {
  echo "<input name=\"color[]\" type=\"checkbox\" value=\"$color\" CHECKED> $color ";
      } else
      {
  echo "<input name=\"color[]\" type=\"checkbox\" value=\"$color\"> $color";
              }
          }

This worked perfectly, if user tick unchecked input ( worked ) but if user change any color ( if input checked change to unchecked ) send old checked input and not send new data to mysql database.

How To fix this?
Thanks

[watdaflip]

I'm kind of confused as to what your question is, however in general you've got the outputting of data from the db correct, just update it with whatever data you get. You don't have to worry about what has been checked or unchecked, just update the column in the table with all that has been checked. I'm not sure if your question was how to get the data, incase it was $_POST['color'] will be an array of the submitted data.

Sorry if that doesn't answer your question, but I couldn't figure out what it actually was