Get select multiple options into one variable.

[regoch]

Hi! I got this script for inserting jobs from multiple select, but can not get it work. I wonna all data from "select info_dodatni_posao" to get in one variable and put it in mysql database. I try this way thats below but not working! Any ideas? When I remove [] i get it to put just one job in mysql even if i select 3 or more.

 

test.html

<select multiple="multiple" name="info_dodatni_posao[]" id="info_dodatni_posao[]">
<option value='Certified Beauty Therapist'>Certified Beauty Therapist</option><option value='Certified Dive Master'>Certified Dive Master</option><option value='Certified Diver'>Certified Diver</option><option value='Certified Hair Dresser'>Certified Hair Dresser</option><option value='Certified Personal'>Certified Personal</option></select>

test.php

$info_id = $_POST['info_id'];
$info_dodatni_posao = $_POST['info_dodatni_posao[]'];
$qry = "UPDATE tz_info SET  info_dodatni_posao='$info_dodatni_posao' WHERE info_id='$info_id'";
$result = @mysql_query($qry);

[Barand]

You should correctly normalise your tables and write a row for each selected item.

 

But if you insist on storing multiple items you can use join() on the $_POST item to get a comma-separated list.

[regoch]

join()  do the work! Thanks!

[thara]

hi... regoch..

 

how can we use join()... can you post your code to see us..

 

thank you..

[regoch]

$info_id = $_POST['info_id'];
$info_dodatni_posao = join(", ", $_POST['info_dodatni_posao']);
$qry = "UPDATE tz_info SET  info_dodatni_posao='$info_dodatni_posao' WHERE info_id='$info_id'";
$result = @mysql_query($qry);

 

I add join() in second line and get all multiple post in one field in database with , between like this

Full Time, Full Time Rotational, Freelance