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??

 

[Nhoj]

Could try something like:

 

<?php
$typeList = $_POST['typeList'];

foreach ($typeList as $key => $tmpType) {
     $tmpType = trim($tmpType);
     mysql_query('INSERT INTO `position` VALUES ("'.$position.'", "'.$tmpType.'")') or die ('Query Failed: '.mysql_error());
}
?>

[phpsql1]

$_POST['typeList'] holds only the selected item.

can anyone help