How to populate HTML dropdown list with values from database

Question

as part of a HTML form I am creating I would like to have a dropdown list which will list all the usernames in my database.

I thought the following code would do the trick but the dropdown list is empty - could someone assist me in what i'm doing wrong? Thanks.

<tr> <td>Owner</td> <td> <select name="owner"> <?php   $sql = mysqli_query($connection, "SELECT username FROM users");  while ($row = $sql->fetch_assoc()){  ?> <option value="owner1"><?php echo $row['username']; ?></option>  <?php // close while loop  } ?> </td> </tr> 

Answer 1

My guess is that you have a problem since you don't close your select-tag after the loop. Could that do the trick?

<select name="owner"> <?php  $sql = mysqli_query($connection, "SELECT username FROM users"); while ($row = $sql->fetch_assoc()){ echo "<option value=\"owner1\">" . $row['username'] . "</option>"; } ?> </select>