title: PHP : insert multiple check boxes values into one MySQL column
body: <p>I want to write a simple PHP function to insert values of 10 and 20 check boxes. Now, the issue is: should I insert all values in a single column of MySQL table or should I go with the separate table?</p>
  
  <p>My main goal is to insert the values of multiple checkboxes into MySQL and then update them. If I checked 7 checkboxes, and after some time I want to update from 7 to 5, how it will remove values from table column?</p>
  
  <p>Please help me with some kind simple PHP example and what type of MySQL fields should I add, becuase I want to insert checkbox value which should in digital and the label of check boxes in other field.</p>
  
  <p>Here is the HTML I have </p>
  
  <pre><code>&lt;form method="post" action=""&gt;
     Games You Like: &lt;br/&gt;
     &lt;input type="checkbox" name="games[]" value="1"&gt;&lt;label&gt;Football&lt;/label&gt;&lt;br&gt;
     &lt;input type="checkbox" name="games[]" value="2"&gt;&lt;label&gt;Basket Ball&lt;/label&gt;&lt;br&gt;
     &lt;input type="checkbox" name="games[]" value="3"&gt;&lt;label&gt;Pool&lt;/label&gt;&lt;br&gt;
     &lt;input type="checkbox" name="games[]" value="4"&gt;&lt;label&gt;Rugby&lt;/label&gt;&lt;br&gt;
     &lt;input type="checkbox" name="games[]" value="5"&gt;&lt;label&gt;Tennis&lt;/label&gt;&lt;br&gt;
     &lt;input type="checkbox" name="games[]" value="6"&gt;&lt;label&gt;Cricket&lt;/label&gt;&lt;br&gt;
     &lt;input type="checkbox" name="games[]" value="7"&gt;&lt;label&gt;Table Tennis&lt;/label&gt;&lt;br&gt;
     &lt;input type="checkbox" name="games[]" value="8"&gt;&lt;label&gt;Hockey&lt;/label&gt;&lt;br&gt;
     &lt;input type="submit" name="submit" value="submit"&gt;
  &lt;/form&gt;
  </code></pre>