populate drop down list from resultset of mysql query

[ankit1122]

hello,
how could i populate drop down list from resultset of a mysql query??

[v1shwa]

Assuming you use mysqli_ extension, here is a sample code that might help you.

<?php
    echo "<select>";
    $result = mysqli_query("SELECT * FROM table_name");
    while($row=mysqli_fetch_array($result)){
        echo "<option value='".$arr['option_number']."'>";
        echo  $row['option_name'];
        echo  "</option>";
     }
     echo "</select>";
?>

[abelingaw]

    <?php

        $link = mysqli_connect('localhost', 'root', 'admin','admin') or die("Could not connect database");
        $result=mysqli_query($link, "SELECT * FROM questions");
        $row = mysqli_fetch_assoc($result);
    ?>

        <label for="login-username">Secret Question:</label>
            <select name="sq" id="sq" style="width:250px; height:30px">

                <?php do { ?>
                        <option ><?php echo $row['question'];  ?></option>
                <?php } while ($row = mysqli_fetch_assoc($result)); ?>

            </select> 

[ankit1122]

that is good..
but i want chained dropdown list.

like the options shown in dropdownlist2 is dependable on options of dropdownlist1...

[ankit1122]

i have used this code but this is not working

<form name="f1" action="wel.php" method="post" target="_blank">
            <select id="dbase" name="dbase">
                <?php
                            $link = mysqli_connect('localhost', 'root', '','people') 
                                    or die("Could not connect database");
$result=mysqli_query($link, "show databases");
        while($row=mysqli_fetch_assoc($result))
                {
            echo "<option value='".$row['Database']."'>";
        }
            echo "</option>";

        ?>
        </select>

this is not showing options in dropdown list..

[v1shwa]

You forgot:
1)To use the </option> tag inside the while loop.
2) To give a name to the option.
Change the while part to the following one.

while($row=mysqli_fetch_assoc($result))
{
            echo "<option value='".$row['Database']."'>";
            echo $row['Database'];
            echo "</option>";
}

[diafol]

If you wanted a chained dropdown list, why didn't you state that in your original post? Have a look in the "code snippets" section of this forum. I provided 2 articles on linked dropdowns - you may find them useful.

[ankit1122]

please see the post and reply

http://www.webdeveloper.com/forum/showthread.php?300693-cant-get-post-value-for-second-dropdown-list

[diafol]

Please keep the discussion on site. State clearly what you want and we may be able to help. Asking contributors to search threads on other forums isn't really the way to go.

[ankit1122]

i have supplied u the whole url.no search needed

[diafol]

OK, well if you're happy with that, good luck. Many of us won't click links to external sites. Just a heads up.