填充从数据库下拉的HTML表单

Question

I have been trying to populate a drop down menu by pulling the needed information from a database through php and mysql however I haven't been able to achieve this and so far when I run it I just get a drop down box with nothing inside of it. Any help on this would be great as I am really stuck as to where I am going wrong.

<select id="dung-name-select" name="dung-select">
    <option name="" disabled selected hidden>Name</option>
    <option value="*">All</option>
        <?php 
        //Database Query
        $query = "SELECT Name FROM dungeon";
        $result = mysqli_query($connection, $query);
        if (!$result) {
            die("Database query failed.");
        }
            var_dump($result);
            while($row = mysqli_fetch_assoc($result)) {
        ?>
            <option value="<?= $row['Name']; ?>"><?= $row['Name']; ?></option>;
        <?php
        }
        ?>
</select>

I have connected to the database fine and can pull information down from it to populate a table for example however the drop down menu just isn't working.

NB: I need the value to be set to the name that I am also populating the drop down menu with.

Answer 1

your code works for me, i tried something different hope it works for you.

<select id="dung-name-select" name="dung-select">
    <option name="" disabled selected hidden>Name</option>
    <option value="*">All</option>
     <?php 
        $result = $connection->query("SELECT Name FROM dungeon");
        if ($result) {
            while($row = $result->fetch_assoc()) {
        ?>
            <option value="<?= $row['Name']; ?>"> <?= $row['Name']; ?></option>;
    <?php
                }
        }       
        else {
            echo "No dungeons found"; 
            }
        ?>
</select>