HTML checkbox form php
<p>Hello I have a problem with a Html form sending 0 instead of 1 to my database, it is set as tinyint 1
I have been messing with this for days.</p>

<p>I use phpmyadmin xampp server html php</p>

<pre><code>&lt;!--THIS IS SKILLS--&gt;
 &lt;?php



 $con = mysql_connect("localhost","root","");
 if (!$con)
   {
   die('Could not connect: ' . mysql_error());
   }
if (!isset($_POST['action'])) 

 mysql_select_db("client", $con);
$sql="INSERT INTO skills (driving_licence,HGV,engineer,carpenter,chef,PSV)
 VALUES
 ('$_POST[driving_licence]','$_POST[HGV]','$_POST[engineer]','$_POST[carpenter]','$_POST[chef]','$_POST[PSV]')";

 if (!mysql_query($sql,$con))
   {
   die('Error: ' . mysql_error());
   }
 echo "skills have been added";

 mysql_close($con);

 ?&gt;
</code></pre>

<p>The form code is</p>

<pre><code>&lt;center&gt;&lt;form method="post" action="skills.php"&gt;
&lt;table cellspacing="50"&gt;
&lt;tr&gt;
&lt;center&gt;&lt;h1&gt;Record Client Skills&lt;/h1&gt;&lt;/center&gt;
&lt;center&gt;&lt;p&gt; Please choose the relevent boxes&lt;/p&gt;&lt;/center&gt;


&lt;center&gt;&lt;input type="checkbox" name="driving_licence" value="driving_licence"&gt;I have a Full UK Driving Licence&lt;br&gt;
 &lt;input type="checkbox" name="hdv" value="hgv"&gt;I hold a valid a HGV licence&lt;br&gt; 
 &lt;input type="checkbox" name="engineer" value="engineer"&gt;I have an Engineering qualification &lt;br&gt;
 &lt;input type="checkbox" name="carpenter" value="carpenter"&gt;I have a Carpentry qualification &lt;br&gt;
 &lt;input type="checkbox" name="chef" value="chef"&gt;I have Catering qualification&lt;br&gt;
 &lt;input type="checkbox" name="psv licence" value="psv"&gt;I have a valid PSV licence&lt;br&gt;   
&lt;/tr&gt;   
&lt;/table&gt;

&lt;input type="reset" value="Reset Form"/&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;   &lt;input type="submit" value="Send" /&gt;


 &lt;/center&gt;
</code></pre>

<p>Can anyone help?</p>

<p>Rob</p>
