Inserting data into MySQL using a form with checkboxes

[joelphil]

hello all,

my goal has been to insert data into
mysql using a form with checkboxes:

Here's my basic form:

<form action="POST" METHOD="insertdata.php">

<INPUT type=checkbox name="choice[]" value="one">One
<INPUT type=checkbox name="choice[]" value="two">Two
<INPUT type=checkbox name="choice[]" value="three">Three
<INPUT type=checkbox name="choice[]" value="four">Four

<INPUT type=submit name=submit value="Submit">

Here is basic table for info"

$sql = Insert into tbl_name (choice1,choice2, choice3, choice4) VALUES (...

you get the picture. so, I have tried counting array and using foreach but, I am unable to resolve this problem. any help would be great. thanks.

🙂

[Houdini]

Maybe if you showed the entire code that you are using to process the form data besides just the query you might get some help (advice).

[joelphil]

here's my current receiving script for this form:

<?php

include('db_conx.php');

$SQL = "INSERT INTO testform (checkbox1, checkbox2) VALUES (".$POST['checkbox1']. "," .$POST['checkbox2'].")";

if(!$result = @($SQL)){
echo 'There was a problem submitting your information';

} ELSE {

echo 'good job, it worked';

}

?>

when I run the form, it brings up error "There was a problem submitting your information""

any suggestions?