create a "select element"

/* written by LiYongQuan */

/* fetch data from a table, this table must contain two columns, one is department's ID, and another is department's name */

function department($all="T",$specify="N")
{
 include "./tools/con_db.php";
 $con=mysql_connect($DB_SERVER,$USER,$PASSWORD);
 mysql_select_db($DB_NAME,$con);
 $query="select * from Department";
 $result=mysql_query($query,$con);
 echo("");
 while($row=mysql_fetch_array($result))
    {if($specify==$row["DID"])
        $sel="selected";
     else $sel="";
     $DID=$row["DID"];
     $DName=$row["DName"];
     echo("$DName");
    }
 if($all=="T")
    {if($specify=="%")
        $sel="selected";
      else
        $sel="";
      echo("所有部门");
    }
 echo("");
 mysql_close($con);
 unset($result);
}