[studenteye]

Hi,

Plz Help Me !!

I have created one drop down multi select list in html.

I want to store all elements of that list selected by visitor of my website into

mysql database by using php.

I want to insert seprate rows in database for each selected element

Is it possible

[georgian]

You need to name your multi select list with [] after it example:

PHP Code:

<select name="MyList[]" size="3" multiple>

  <option value="One">1</option>

  <option value="Two">2</option>

  <option value="Three">3</option>

</select> 

Then when you submit the form to process the values that are selected...

PHP Code:

//$_POST[MyList] will be an array containing all the values selected by the user.

foreach( $_POST[MyList] as $val ){

    mysql_query( "INSERT tbl_Temp SET Value = '$val' ");

} 

Hope this helps.
Cheers