Dropdown from SQL, Display "Choose One"

[dougp23]

I think the title summarizes what I am trying to do!

I use a SQL statement to build the list of options:

$sSQL="SELECT generations_id, generations_desc FROM generations ORDER BY...";
$generations=$db->query($sSQL);

So I get all the choices, and I display the text but store the ID. That's all fine. But I want the dropdown to say "Choose". Even better, it should say nothing, and if the user makes no selection, we should store a null.

Absolutely stumped, have tried concat'ing a " " to the end of the results, but no go.

[NogDog]

Not sure if this is what you mean:

<select name='foo'>
<option value='' selected='selected'>Choose one...</option>
<?php
while($row = mysql_fetch_assoc($result))
{
   echo "<option value='".$row['id']."'>".$row['value']."</option>\n";
}
?>
</select>