How can I enter the data of a query from a database in mysql in a jump menu?

Question

How can I enter the data of a query from a database in mysql in a jump menu?

Navigation

#1 by (2 votes)

0

if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
    <select id="nom" name="nom">
    <option value="1"> .$row['nombre']. </option>
    </select>
}

html php

asked by Alejandro Esquivel 05.03.2018 в 02:52

source

1 answer

Problems with an associative Array in php Remove separation between cells

score 2 · Accepted Answer

Be sure to place the code next time, it's easier.

I do not accept the impression of the select because the instructions

<select name="nom" id="nom">
    <option value="1">.$row['nombre'].</option>
</select>

they are not php language, you must put everything on text in the following way

echo '<select id="nom" name="nom">';
while($row = $result->fetch_assoc()) {
    echo "<option value=\"1\">{$row['nombre']}</option>";
}
echo '</select>';