<?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="Activity" id="myActivityCombo">
<?php
$sql = "SELECT ID, Status FROM Activity";
$rs = mysql_query($sql) or trigger_error(mysql_error() . " unable to run query.");
echo "<option></option>";
while($row = mysql_fetch_assoc($rs))
{
echo "<option value=\"".$row['ID']."\">".$row['Status']."</option>\n  ";
}
?>
</select>