2015-03-10 23:40 浏览 43


im trying to create a drop down many and populate the options from fields in a database that i have. So far i have got the following code:


$query = "SELECT Category FROM books";
$result = mysqli_query ($mysqli, $query);

echo "<select name=dropdown value=''>Dropdown</option>";
while($row = mysqli_fetch_array($result))
    echo "<option value=$row[Category]>$row[Category]</option>";

echo "</select>";

However when i try to view the page nothing seems to happen. My page remains blank and all i see is the color that i gave to the body in the css file.

Was wondering if anyone knew wh this was happening and if they can sort it out?


  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

1条回答 默认 最新

  • 已采纳
    douping5226 douping5226 2015-03-11 00:08

    Assuming you are getting results from your query. Can find out by print_r($result). Think you are getting death screen because of quotes and missing opening for first option in dropdown.

    echo '<select name="dropdown" value=""><option value="">Dropdown</option>';
        while($row = mysqli_fetch_array($result))
            echo '<option value="' . $row['Category'] . '">' . $row['Category'] . '"</option>';
        echo "</select>";
    点赞 评论 复制链接分享