CODEWITHSUNDEEP
phphtmlmysql
user3103739
user3103739

Reputation: 97

PHP/MYSQL Could not display data from MYSQL in Drop Down Box

I am having a problem displaying data from MYSQL into drop down box.

Output:

<html>
<body>
    <form name=displayQuestion>
        Survey Categories : 
        <select name="surveyCategory">
        <option> Choose Survey Category </option>
        <?php
            $surveyQuery = "SELECT survey_id, survey_name FROM surveys";
            $result = mysql_query($surveyQuery) or die (mysql_error());
            while($menu=mysql_fetch_assoc($result)){
                echo "<option value=$menu[survey_id]>$menu[survey_name]</option>";                  
            }
        ?>
    </select>
    </form>
</body>
</html>

Upvotes: 0

Views: 192

Answers (2)

virmaior
virmaior

Reputation: 424

no reason to use that ugly formatting:

echo '<option value="' . $menu['survey_id'] . '">' . $menu['survey_name'] . '</option>';

Upvotes: 1

Ignacio Ocampo
Ignacio Ocampo

Reputation: 2713

You need put your option value within quotes and access array with simple quotes like as:

echo "<option value=\"$menu['survey_id']\">$menu['survey_name']</option>";

Upvotes: 1

Related Questions