How To Create A Dynamic Drop Down List In Php Populated From Mysql Database

I am trying to create a dynamic drop down list using PHP and mysql database. I have written the following code and its giving me the output, but the problem is that its showing dif

Solution 1:

Get rid of the inner foreach loop... it is doing nothing for you and move the start and end select tags outside of the while loop.

$select_query=          "Select name from category";
$select_query_run =     mysql_query($select_query);
echo"<select name='category'>";
while ($select_query_array=   mysql_fetch_array($select_query_run) )
{
   echo"<option value='' >".htmlspecialchars($select_query_array["name"])."</option>";
}
echo"</select>";

Solution 2:

take look at this code.

$select_query=          "Select name from category";
$select_query_run =     mysql_query($select_query);

echo"<select>";
while   ($select_query_array=   mysql_fetch_array($select_query_run) )
{
        echo"<option value='' >".$select_query_array['name']."</option>";                        
}
echo"</select>";

Solution 3:

<?php$res = mysqli_query($conn, "SELECT DISTINCT coloumn_name FROM table_name;" );
while($row = mysqli_fetch_array($res))    
{
    echo"<option value='" . $row['selected_coloumn']. "'>" . $row['selected_coloumn'] . "</option>";
}
?>

In this example please select your 'coloumn_name' and 'table_name'.

Solution 4:

$select_query= "Select name from category";
$select_query_run =     mysql_query($select_query);
$selectTag = "<select>";
while   ($select_query_array=   mysql_fetch_array($select_query_run) ){
    foreach ($select_query_arrayas$select_query_display){
        $selectTag .="<option value='' >$select_query_display</option>";
    }
}
$selectTag .= "</select>";

   echo$selectTag;

Solution 5:

You may try it

$select_query=          "Select name from category";
    $select_query_run =     mysql_query($select_query);
    $select_query_array=   mysql_fetch_array($select_query_run)
    $select = "<select>";
    foreach ($select_query_arrayas$val)
    {
        $select .= "<option value='".$val['name']."' >".$val['name']."</option>"; 


    }

    $select = "</select>";

    echo$select;

Hope It will work