Need help for a game, php form and mysql : <p>I have many problems with a form that I have to create...</p>

<pre><code>&lt;form  method="post" action="target.php" id="myForm"&gt;
    &lt;span class="form_col"&gt;Name&lt;/span&gt;
    &lt;input /&gt;
    &lt;br /&gt;&lt;br /&gt;

    &lt;span class="form_col"&gt;Gender :&lt;/span&gt;
    &lt;label&gt;&lt;input name="sex" type="radio" value="H" /&gt;Male&lt;/label&gt;
    &lt;label&gt;&lt;input name="sex" type="radio" value="F" /&gt;Female&lt;/label&gt;
    &lt;br /&gt;&lt;br /&gt;

    &lt;label class="form_col"&gt;Race :&lt;/label&gt;
    &lt;label&gt;&lt;input type="radio" value="Human" /&gt;Human&lt;/label&gt;
    &lt;label&gt;&lt;input type="radio" value="Elf" /&gt;Elf&lt;/label&gt;
    &lt;label&gt;&lt;input type="radio" value="Orc" /&gt;Orc&lt;/label&gt;
    &lt;br /&gt;&lt;br /&gt;

    &lt;label class="form_col"&gt;Primary color :&lt;/label&gt;
    &lt;select name="prcolor" id="prcolor"&gt;
        &lt;option value="none"&gt;Select the primary color&lt;/option&gt;
        &lt;option value="blue"&gt;Blue&lt;/option&gt;
        &lt;option value="red"&gt;Red&lt;/option&gt;
        &lt;option value="yellow"&gt;Yellow&lt;/option&gt;
        &lt;option value="black"&gt;Black&lt;/option&gt;
    &lt;/select&gt;
    &lt;br /&gt;&lt;br /&gt;

    &lt;label class="form_col" for="firstName"&gt;Body color :&lt;/label&gt;
    &lt;select name="bcolor" id="bcolor"&gt;
        &lt;option value="base"&gt;Base&lt;/option&gt;
        &lt;option value="redb"&gt;Red&lt;/option&gt;
        &lt;option value="brownb"&gt;Brown&lt;/option&gt;
        &lt;option value="blackb"&gt;Black&lt;/option&gt;
    &lt;/select&gt;
    &lt;br /&gt;&lt;br /&gt;

    &lt;label class="form_col"&gt;Hair color :&lt;/label&gt;
    &lt;select name="hair" id="hair"&gt;
        &lt;option value="none"&gt;Select the color&lt;/option&gt;
        &lt;option value="blackh"&gt;Black&lt;/option&gt;
        &lt;option value="greyh"&gt;Grey&lt;/option&gt;
        &lt;option value="brownh"&gt;Brown&lt;/option&gt;
    &lt;/select&gt;
    &lt;br /&gt;&lt;br /&gt;

    &lt;span class="form_col"&gt;Weapon :&lt;/span&gt;
    &lt;label&gt;&lt;input type="radio" value="sword" /&gt;Sword&lt;/label&gt;
    &lt;label&gt;&lt;input type="radio" value="shield" /&gt;Shield&lt;/label&gt;
    &lt;label&gt;&lt;input type="radio" value="knife" /&gt;Knife&lt;/label&gt;
    &lt;label&gt;&lt;input type="radio" value="wand" /&gt;Wand&lt;/label&gt;
    &lt;br /&gt;&lt;br /&gt;

    &lt;span class="form_col"&gt;Clothes :&lt;/span&gt;
    &lt;label&gt;&lt;input type="checkbox" value="armor" /&gt;Armor&lt;/label&gt;
    &lt;label&gt;&lt;input type="checkbox" value="coat" /&gt;coat&lt;/label&gt;
    &lt;label&gt;&lt;input type="checkbox" value="dress" /&gt;Dress&lt;/label&gt;
    &lt;br /&gt;&lt;br /&gt;

    &lt;span class="form_col"&gt;Accessory :&lt;/span&gt;
    &lt;label&gt;&lt;input type="checkbox" value="hat" /&gt;Hat&lt;/label&gt;
    &lt;label&gt;&lt;input type="checkbox" value="helmet" /&gt;Helmet&lt;/label&gt;
    &lt;label&gt;&lt;input type="checkbox" value="glasses" /&gt;Glasses&lt;/label&gt;
    &lt;br /&gt;&lt;br /&gt;

    &lt;span class="form_col"&gt;Pet :&lt;/span&gt;
    &lt;label&gt;&lt;input name="sex" type="radio" value="mount" /&gt;Mount&lt;/label&gt;
    &lt;label&gt;&lt;input name="sex" type="radio" value="pet" /&gt;Pet&lt;/label&gt;
    &lt;label&gt;&lt;input name="sex" type="radio" value="none" /&gt;None&lt;/label&gt;
    &lt;br /&gt;&lt;br /&gt;

    &lt;span class="form_col"&gt;&lt;/span&gt;
    &lt;input type="submit" value="Send" /&gt;
&lt;/form&gt;
</code></pre>

<p>I need to send these informations to a database, but i don't know how to do...
And on mysql i don't know which type i need to use for each information...</p>

<p>Anyone can help me to make this form functional ?
Actually i really don't know how to do, I did some research but no results..</p>

<p>Thanks in advance</p>
