Help with inserting multiple select values

ali_p

Hi, i have a multiple select box which i'm using to get values for a field in my table. Now on my insert page i have this

if (isset($_POST['other_room']) && is_array($_POST['other_room'])) { 
  foreach ($_POST['other_room'] as $value0);
}

in my sql insert i have
INSERT INTO residential_properties
VALUES ('', '$value0', )

etc.

However on one option is actually going into the database, why is this please.

Thanks in advance.

bpat1434

Because you're not doing anything with the $value0.

It should probably be something like:

$room = '';
foreach ($_POST['other_room'] as $value0){
    $room .= $value0.',';
}
$room = substr($room, 0, -1); // Remove the last comma

Then you have a comma seperated value as your input in mySQL.

INSERT INTO residential_properties
VALUES ('', '$room', )

~Brett

ali_p

Thats perfect! many thanks indeed for that.
I have another question along the same lines, its to do with editing the same field.
So now i want to edit my table using a html form. I can get the field contents displayed but how do i edit the contents. Say the field contains
bedroom, bathroom, lounge etc.
I want the user to be able to add to this using the multiple select box, is this possible??

I have the contents displayed in a text field so to delete would be easy but they need the select box to add.

Thanks in advance

bpat1434

Create a while loop listing all the places they can add (as opposed to those they have already added) and put it within a list box.

~Brett