multiple check boxes values on one submit

[malik]

can some body figuer out how to fix this code so it will update the checkbox values on one submit , right now it is updating all the values of the checkboxes in the career field to the one submitted the last and i have only one field career in the sql table and all the checked values should go into that field if they are checked. so there are two queries insert and update can any tell me a better way

if($action == "insert") {

$fn="first_name";
$social="ssn";
$maj="major";
$stan="standing";

$intern="internship";


$query="insert into  user (name,ssn,major,standing,career,internship) ";
$query.= "VALUES ('${$fn}', '${$social}', '${$maj}', '${$stan}' , '${$career}', '${$intern}')";

if (isset($Career_Array)) {

$career = implode($Career_Array, ",");

$result = mysql_query ("update  user   SET career ='$career'");


}

echo $query;

mysql_query($query) or die ("could not insert ");



 }//endif action insert

the check boxes are reference by Career_Array
<input type=checkbox value="career services offered in engineering" name="Career_Array[]"></td><td> Career Services offered in the college of Engineering & Technology</td></tr>
<input type=checkbox value="Unl Career service" name="Career_Array[]"></td><td>&nbsp UNL Career Services</td></tr>
<input type=checkbox value="Husker hire link" name="Career_Array[]"></td><td> Husker Hire Link</td></tr>
<input type=checkbox value="Career Fair" name="Career_Array[]"></td><td> Career Fair</td></tr>

will appreciate your help

[trooper]

OK first things first

You want to perform multiple inserts. In that case you will need to do a loop for each of the items in your CAREER_ARRAY

I am assuming that you are using a method of POST for your form

So something like this

foreach($_POST['CAREER_ARRAY'] as $key=>$value)
{
ADD YOUR QUERY TO INSERT THE DATA HERE
}

That will loop through your array that is contained in CAREER_ARRAY. You will still have to actually write the query to do the insertion but that should not be too difficult

HTH

GM

Originally posted by malik
can some body figuer out how to fix this code so it will update the checkbox values on one submit , right now it is updating all the values of the checkboxes in the career field to the one submitted the last and i have only one field career in the sql table and all the checked values should go into that field if they are checked. so there are two queries insert and update can any tell me a better way


if($action == "insert") {

$fn="first_name";
$social="ssn";
$maj="major";
$stan="standing";

$intern="internship";


$query="insert into  user (name,ssn,major,standing,career,internship) ";
$query.= "VALUES ('${$fn}', '${$social}', '${$maj}', '${$stan}' , '${$career}', '${$intern}')";

if (isset($Career_Array)) {

$career = implode($Career_Array, ",");

$result = mysql_query ("update  user   SET career ='$career'");


}

echo $query;

mysql_query($query) or die ("could not insert ");



 }//endif action insert

the check boxes are reference by Career_Array
<input type=checkbox value="career services offered in engineering" name="Career_Array[]"></td><td> Career Services offered in the college of Engineering & Technology</td></tr>
<input type=checkbox value="Unl Career service" name="Career_Array[]"></td><td>&nbsp UNL Career Services</td></tr>
<input type=checkbox value="Husker hire link" name="Career_Array[]"></td><td> Husker Hire Link</td></tr>
<input type=checkbox value="Career Fair" name="Career_Array[]"></td><td> Career Fair</td></tr>

will appreciate your help [/B]

[malik]

if($action == "insert") {

$fn="first_name";
$social="ssn";
$maj="major";
$stan="standing";
$intern="internship";

$query="insert into  user (name,ssn,major,standing,career,internship) ";
$query.= "VALUES ('${$fn}', '${$social}', '${$maj}', '${$stan}' , '${$career}', '${$intern}')";

foreach($POST['CAREER_ARRAY']as_$key=>$value) {

 $career = implode($Career_Array , ",");

$result = mysql_query ("update user set  career ='$career'") or die (mysql_error());


 }



echo $query;

mysql_query($query) or die ("could not insert ");

thankyou very much trooper for your help

this is giving me a parse error before the $query starts i.e end of $intern variable
and when i remove foreach block of function the error is gone it is basically due to
for each function

can you see if the query is at the right place  

}//endif action insert

[trooper]

OK well first thing is first.

it should be

foreach($_POST['CAREER_ARRAY'] as $key=>$value)

not

foreach($_POST['CAREER_ARRAY']_as_$key=>$value)

let me know what happens

GM