[Resolved] Populating Drop down boxes with data from database

[Calahan]

Can anyone tell me if it is possible to populate a drop down box with data from a database? For example,

<form name="form1" method="post" action="">
  <select name="username" size="1">
  <option value="name1">Name1</option>
  <option value="name2">Name2</option>
  <option value="name3">Name3</option>
  <option value="name4">Name4</option>
  <option value="name5">Name5</option>
  <option value="name6">Name6</option>
</select> 
</form>

I would like the selections to be populated from a table containing names of users.

Thanks for any pointers anyone can give me.

[LordShryku]

Yes it's possible. Been talked about many times too. Try searching the forums.

[mistafeesh]

ooh I can help here!
pasted straight from one of my sites:

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

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

hope that helps! it's Dreamweaver generated code, by the way.

[Calahan]

Thanks mistafeesh. That's enough to point me in the right direction.