<?php
$username="User";
$password="Pass";
$database="DB";

mysql_connect('localhost',$username,$password) or trigger_error( mysql_error() . " Unable to connect to database");
mysql_select_db($database) or trigger_error( mysql_error() . " Unable to select database");

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