<select name="Department">
<?php
$sql = "SELECT Department FROM Department";
$rs = mysql_query($sql) or trigger_error(mysql_error() . " unable to run query.");
while($row = mysql_fetch_assoc($rs))
{
  echo "<option value=\"".$row['Department']."\">".$row['Department']."</option>\n  ";
}
?>