Code:
<?php
$fp = mysql_connect("localhost","username","password");
mysql_select_database("databasename");
$sql = "
SELECT *
FROM someTable
WHERE something = \"".$someVar."\"
";
if(!($result = mysql_query($sql))) {
echo "No dice.";
} else {
echo "<select name=\"myDropDownList\">";
while($row = mysql_fetch_array($result)) {
echo "<option value=\"".
$row['someField']."\">".$row['someOtherField']."</option>";
}
echo "</select>";
}
?>