[SOLVED] inserting the values of a list into a table

[phpsql1]

I am really stacked on how to insert all the values of a dropdown menu (select tag) into a mysql table. I am not dealing with multiple selections here.

I tried foreach function but it did not work.

Below is the some of what I did.

 

Here is the definition of the List:

<select name="typeList" size="5">

<option>Student</option>

<option>Faculty</option>

<option>Extra Help</option>

<option>Extra Link</option>

<option>International</option>

</select>

 

Here I assigned the List to a php variable:

$ typeList = trim($_POST[‘typeList]);

 

And here I used the foreach function to go over each value of the List into the MYSQL table (position):

foreach($typeList as $tmpType)

{

$query = "INSERT INTO position(name, type) VALUES ('$position', '$ tmpType ')";

mysql_query($query) or die("Query failed: " . mysql_error());

}

 

The problem with this is that foreach works only with tables, and it did not consider the list variable as a table.

 

Anyone can help??

 

[bubblegum.anarchy]

$_POST['typeList'] holds one item, the selected item.

[phpsql1]

That 's what Inoticed. Howshould I solve this problem

[bubblegum.anarchy]

There is no problem - the $_POST data is supposed to only hold one item, the selected item, this is the purpose of the $_POST data.

[phpsql1]

so then how to insert all the values of a list into a mysql table.

[bubblegum.anarchy]

so then how to insert all the values of a list into a mysql table.

 

One insert at a time for each value in the select box.

[phpsql1]

Ok

that's exactly what am looking for as long as I don't have to select any value of the list.

 

I hope that's what you did mean.

 

Thanks