Posted by Black Shuck on 02/06/06 02:12

I have a form on a PHP page, to add entries to a MySQL database. I have
the simple string fields working fine, but I am having trouble with a
multiple select listbox filling a MySQL ENUM type.

I have assigned my values in the listbox, to match the ENUM values, and if
I add a dump_var of the value of listbox posted to the PHP code, it looks
sensible:

array(3) { [0]=> string(1) "0" [1]=> string(1) "2" [2]=> string(1) "4" }

The problem is, how do I parse this into a format I can pass into the
MySQL query for the ENUM field?

Can some nice person give a newbie a clue? I figure this must be a common
thing to do...

• Next in forum: Re: Listing table data with an option to delete each individual item.
• Prev in forum: Re: Passing values from drop down menu
• Thread view: Newbie problems with Multiple Select form, and MySQL ENUM types.

[Reply to this message]