title: Update value from 0 to 1 in mysql table with checkbox
body: <p>MYSQL Table structure</p>
  
  <pre><code>Name    Type            Collation         Attributes    Null    Default
  code    varchar(2)      utf8_unicode_ci                  No     
  name    varchar(255)    utf8_unicode_ci                  No     
  checkbox  tinyint(1)                                     Yes       NULL
  </code></pre>
  
  <p>PHP</p>
  
  <pre><code>$countryiso = mysql_query("SELECT distinct name as name FROM location_country where code NOT IN('A1','A2','AP','EU') order by name");
  echo '&lt;table&gt;';
  echo '&lt;th&gt;Country&lt;/th&gt;&lt;th&gt; Add/Remove &lt;/th&gt;';
  while ($row = mysql_fetch_assoc($countryiso)) {
   echo '&lt;tr&gt;';
   echo '&lt;td&gt;'. $row['name'] . '&lt;/td&gt;';
   echo '&lt;td&gt;&lt;input type="checkbox"&gt;&lt;/td&gt;';
   echo '&lt;/tr&gt;';
  }
   echo '&lt;/table&gt;';
  </code></pre>
  
  <p>I need to update a value from column checkbox from 0 to 1 when i check the checkbox in my php backend. How do i do this with php and mysql only? Please no Jquery.</p>