html - How to fill combobox in php from mysql table for specified row

Question

I have mysql table that table names' are id and name. I want to fill combobox with names but I couldn't figure out how to fill with only names. When I do this

     <?php  foreach($category as $key => $value   )   {

                                  ?>
                                  <option><?php echo $value?></option> 
                                  <?php }?>

It fills combobox with ids and names.

Answer 1

Since PHP's forEach only works on Arrays, your $key is just going to be the index of each element in the array, you want to retrieve the part of $value that corresponds to name but that depends on if you have that value as an object or an array, if $value is an object try

$value["name"] 
//Or
$value.name
//Or
$value->name

(Sorry I forget the syntax for objects in PHP)

if $value is an array use

$value[1]