insert multiple choices into mysql field

yes they do look terribly complicated

omg XD so complecated codes XD, thanks anyway

Thank you David. I appreciate your help.

awsweb wrote:
> I have a form that inserts a record into mysql. it's working fine except when i
> changed the pull-down menu to a list allowing multiple selections, it only
> inserts the last item selected.

That's because you're not sending the form data as an array.

Change this:

<select name="not_reen_list"

to this:

<select name="not_reen_list[]"

At the top of the PHP script, convert the array to a comma-separated
string by adding this:

if (isset($_POST['not_reen_list'])) {
$_POST['not_reen_list'] = implode(',', $_POST['not_reen_list']);
}

I know it should insert the valuse as comma
> separated. Here's the php:
> GetSQLValueString($_POST['not_reen_list'], "text"),
> and the HTML:
> <select name="not_reen_list" size="10" multiple="multiple" id="not_reen_list">
> <option value="Nothing selected" selected="selected">Please select
> one</option><option value="Cost">Cost</option>
> <option value="School could not meet our financial aid needs"> School
> could not meet our financial aid needs </option>
> <option value="Prefer another school">Prefer another school </option>
> </select>
> Any help is appreciated.
>


--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/