将组合框中的选定项目设置为“请选择...”

Question

I'd like to add "Please select..." as the first option in my combobox. See code below - any suggestions?

Regards, Peter

<?php

mysql_connect ("localhost", "username", "password"); 
mysql_select_db('mysqldb');

$sql = "SELECT data_id FROM projects";
$result = mysql_query($sql);

echo "<select name='data_id '>";
$sql[0] = 'Please select...';
while ($row = mysql_fetch_array($result)) 
{
    echo "<option value='" . $row['data_id '] . "'>" . $row['data_id'] . "</option>";
}
echo "</select>";

?>

Answer 1

replace $sql[0] = 'Please select...';
to this echo '<option value="" disabled>Please select...</option>';