Menu
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> 
361
HTML provides <select> tag to create Dropdown List. In fact using <select> tag you can create following types of HTML list controls: Dropdown List (by default) ListBox (by adding size attribute)
This can be achieved using cell edit template feature on the dropdown columns and in the first dropdown's change event, the second dropdown data can be modified(using query property) based on the selected value.
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> If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
