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>