How to add a default "Please Select" option to a dynamic dropdown menu

[maxwell_]

Hi

I have a drop dynamic down menu generated from a database.
I would like to add a default "Please select" option when the menu is originally shown.
I do not need to reset the value back to dault as the page is directed to another page
when the form is submitted.

PHP Code fore dropdown menu -

$query_staff_list = "SELECT * FROM computers ORDER BY name ASC";
$staff_list = mysql_query($query_staff_list, $abe) or die(mysql_error());
$row_staff_list = mysql_fetch_assoc($staff_list);
$totalRows_staff_list = mysql_num_rows($staff_list);

<select name="name" id="name">
      <?php
do {  

?>
      <option value="<?php echo $row_staff_list['name']?>"><?php echo $row_staff_list['name']?></option>
      <?php
} while ($row_staff_list = mysql_fetch_assoc($staff_list));
  $rows = mysql_num_rows($staff_list);
  if($rows > 0) {
      mysql_data_seek($staff_list, 0);
	  $row_staff_list = mysql_fetch_assoc($staff_list);
  }

[/SIZE]

[bradgrafelman]

Looks like all you need to do is add the relevant HTML before (or after) the do/while() loop that outputs the database-driven options.

What have you tried?

[maxwell_]

Hi
Yes that did it.
So simple.

Many thanks for helping with this.

Best regards Maxwell

Dynamic Dropdown menu with default option selected.

<select name="pub_access" id="pub_access"><option selected="selected">Please Select</option>
      <?php
do {  

?>
      <option value="<?php echo $row_pub_access['name']?>"><?php echo $row_pub_access['name']?></option>
      <?php
} while ($row_pub_access = mysql_fetch_assoc($pub_access));
  $rows = mysql_num_rows($pub_access);
  if($rows > 0) {
      mysql_data_seek($pub_access, 0);
	  $row_pub_access = mysql_fetch_assoc($pub_access);
  }
?>
    </select>