Hi

I've got the following snippet of my script which does what it should, ie, get a multiple select from a drop down list:  

Code:

<tr><td>Type</td><td><select name="type[]" multiple>      <option value="action">Action</option>      <option value="comedy">Comedy</option>      <option value="thriller">Thriller</option>      <option value="horror">Horror</option>      <option value="childrens">Childrens</option>      <option value="scifi">Scifi</option>      <option value="fantacy">Fantasy</option>      <option value="adult">Adult</option>      <option value="other">Other</option> </select></td></tr>

The following bit of PHP then grabs the values concerned:

Code:

if(array_key_exists('type', $_GET)) {       $type=join(", ",$_GET['type']);}

Now from that if you were to print $type you get the result you would expect, eg, :

Quote:

comedy, thriller

in this case 2 options, seperated by comas.

The problem is when I try to inset into a mysql db using the following, it only puts in the fist option:

Code:

$query="update dvds set type=\"$type\" where id=$id";

Can you see where I'm going wrong?

PS, the table entry for type is : set ('Action', 'Comedy', etc etc);

Can't see it straight off.   Have you tried running the SQL update manually through a mysql client?   I suspect that would give you (and me!) some further clues.

Right, I run the following query directly, but had the same results, ie, only 1 entry was accepted:

Code:

UPDATE dvds SET type="Action, Comedy" where id=3;

I've also tried variations of the above but can't get it to work, so I guess what I need to know is how to update a SET field ??  I've tried the online manual, but no help, any clues?


OK ... the "set" string in space sensitive and I think I spotted a space in front of your Comedy?   Here's an example that works:

Code:

mysql> select * from try; +----------+------+ | fred     | id   | +----------+------+ | dick     |    3 | | tom      |    4 | | tom      |    5 | | tom,dick |    6 | +----------+------+ 4 rows in set (0.00 sec) mysql> update try set fred = ("dick,harry") where id = 3; Query OK, 1 row affected (0.00 sec) Rows matched: 1  Changed: 1  Warnings: 0 mysql> select * from try; +------------+------+ | fred       | id   | +------------+------+ | dick,harry |    3 | | tom        |    4 | | tom        |    5 | | tom,dick   |    6 | +------------+------+ 4 rows in set (0.00 sec)

Thats cured it.

Thanks again.

---