Show in select database results

Question

I’ve researched this before and I could never get a code that works. When I put the code on, nothing gets a single option.

I wanted a code that could see the data in a select

Code that I’m using:

Serviço: <br>
<select name='servico' id='servico'>
<option>Selecionar Serviço</option>
<?php 
$sql_p= "SELECT nome_prod FROM produtos";
$query=mysqli_query($ligacao,$sql_p);
$rows=array();
while($row=mysqli_fetch_assoc($query)){
    $rows[]=$row;
    echo "<option value=".$rows['nome_prod'].">".$rows['nome_prod']." 
</option>";
}?>
</select>

Answer 1

Use the mysqli_fetch_object direct to display the results in object format.

Serviço: <br>
<select name='servico' id='servico'>
<option>Selecionar Serviço</option>
<?php 
$sql_p= "SELECT nome_prod FROM produtos";
$query=mysqli_query($ligacao,$sql_p) or die(mysqli_error($ligacao);
while($row=mysqli_fetch_object($query)){
    echo "<option value=".$row->nome_prod.">".$row->nome_prod."</option>";
}?>
</select>