Multiselect - PHP & Mysql

[asfaw]

Hello everyone,

I have an HTML form where on of the items is multiselect box where a user may select one or more items on the list.

How would I use PHP to process what has been selected by the user and save the selection in a MySQL database field called department?

How would I use PHP to display on an HTML from what is stored in MySQL database field called department?

E.g. HTML Form
<select name="department[]" size="3" multiple="true">
<option value="finance">Finance</option>
<option value="operation">Operation</option>
<option value="marketing">Marketing</option>

Thank you,

asfaw

[NogDog]

If I correctly understand the question, it would be something like:

<select name="department[]" size="3" multiple="true">
<?php
// do your MySQL connection stuff if you haven't done so already, then...
$sql = "SELECT DISTINCT department FROM tablename ORDER BY department";
$result = mysql_query($sql) or die(mysql_error);
while($row = mysql_fetch_assoc($result))
{
  echo "<option>{$row['department']}</option>\n";
}
?>
</select>

[asfaw]

Thank you for answering the second part of my question. The first part is as follows:
How would I save what is submitted by a user to the database - the user may select one or more from the list of options. I would like to save his/her selection in the department field of the table in the database?

Thank you.

asfaw