[How to store checkbox answers from html form into mysql?]

You should post your code so that people can see what your working with

 

 

Here is my HTML

<p>Please select all body types you would be interested in dating:</p>

<table class=MsoNormalTable border=0 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184;mso-padding-alt:
0in 5.4pt 0in 5.4pt'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'>
  <td width="100%" style='width:100.0%;padding:.75pt .75pt .75pt .75pt'>
  <p class=MsoNormal><span style='mso-fareast-font-family:"Times New Roman"'><INPUT 

TYPE="checkbox" NAME="partnerbodytype[]" VALUE="Slender"> Slender
  <o:p></o:p></span></p>
  </td>
</tr>
<tr style='mso-yfti-irow:1'>
  <td width="100%" style='width:100.0%;padding:.75pt .75pt .75pt .75pt'>
  <p class=MsoNormal><span style='mso-fareast-font-family:"Times New Roman"'><INPUT 

TYPE="checkbox" NAME="partnerbodytype[]" VALUE="Average"> Average
  <o:p></o:p></span></p>
  </td>
</tr>
<tr style='mso-yfti-irow:2'>
  <td width="100%" style='width:100.0%;padding:.75pt .75pt .75pt .75pt'>
  <p class=MsoNormal><span style='mso-fareast-font-family:"Times New Roman"'><INPUT 

TYPE="checkbox" NAME="partnerbodytype[]" VALUE="Athletic"> Athletic
  <o:p></o:p></span></p>
  </td>
</tr>
<tr style='mso-yfti-irow:3;mso-yfti-lastrow:yes'>
  <td width="100%" style='width:100.0%;padding:.75pt .75pt .75pt .75pt'>
  <p class=MsoNormal><span style='mso-fareast-font-family:"Times New Roman"'><INPUT 

TYPE="checkbox" NAME="partnerbodytype[]" VALUE="Heavy"> Heavy
  <o:p></o:p></span></p>
  </td>
</tr>
</table>

</div>

</div>

 

 

And here is my php

 

$partnersbodytype = $_POST['partnersbodytype']

$sqlClientInfo= "INSERT INTO `Client_Info` (Partners_Body_Type) VALUES ($partnersbodytype)

[How to store checkbox answers from html form into mysql?]

Hello,

 

I've been trying to insert checkbox answers from an html form into a mysql database. Any way to do this? Is there a specific code for this? On my html form, my radio buttons and drop-down boxes work just fine, so I assume there is something different I have to do for checkbox answers.

 

I am using MySql 5.1.52, phpmyadmin 3.3.10.2 and php 5.2.17.

 

If you need the code, just let me know.

 

Thank you.