error..insert multiple value in "Select Option" in table?
Posted: Wed Nov 09, 2011 12:26 am
Hi,
I created "scrollble Multi Select Option" as per below code.
<form name=myform>
<select name=mytextarea size=3 multiple>
<option name=one value=one> one </option>
<option name=two value=two> two </option>
<option name=three value=three> three </option>
<option name=four value=four> four </option>
</select>
</form>
---------------------------
but when i am inserting this value via php page into mysql table "tab1",only last selected value is getting inserted.
insert into tab(col1)
values($_POST['mytextarea ']);
plz let me know where i m wrong....thnx in advance
I created "scrollble Multi Select Option" as per below code.
<form name=myform>
<select name=mytextarea size=3 multiple>
<option name=one value=one> one </option>
<option name=two value=two> two </option>
<option name=three value=three> three </option>
<option name=four value=four> four </option>
</select>
</form>
---------------------------
but when i am inserting this value via php page into mysql table "tab1",only last selected value is getting inserted.
insert into tab(col1)
values($_POST['mytextarea ']);
plz let me know where i m wrong....thnx in advance