我正在尝试将来自newproduct mysql表的productname显示到combobox中。下面的代码正在执行，但它显示一个空白

Question

**<html>
<body>
<form name="call">
     <select name="category">
<option>Select a category</option>
<?php
 mysql_connect("localhost","root","");
 mysql_select_db("shenvel");
 $category = "SELECT productname FROM newproduct";
 //retrieving product name alone from newproduct
 $query_result = mysql_query($category);
 while($result = mysql_fetch_assoc($query_result))
{
    ?>
        <option value = "<?php echo $result['productname']?>"><?php echo $result['productname']?></option>  

//上面的代码显示带有一个空格的组合框作为输出。

                \*\*

Answer 1

使用mysql_fetch_array()更改获取记录

while($result = mysql_fetch_array($query_result))
{
   *********
}

试一试..

Answer 2

尝尝这个

<select name="category">
<option>Select a category</option>
<?php
  mysql_connect("localhost","root","");
  mysql_select_db("shenvel");
  $category = "SELECT productname FROM newproduct";

  $query_result = mysql_query($category);
  while($result = mysql_fetch_array($query_result))
  {
 ?>
    <option value = "<?php echo $result['productname']; ?>"><?php echo $result['productname']; ?></option>  
  <?php
  }
  ?>
  </select>

Answer 3

试试这个：

<html>
<body>
<form name="call">
     <select name="category">
<option>Select a category</option>
<?php
 mysql_connect("localhost","root","");
 mysql_select_db("shenvel");
 $category = "SELECT productname FROM newproduct";
 //retrieving product name alone from newproduct
 $query_result = mysql_query($category);
 while($result = mysql_fetch_array($query_result))
{
    ?>
        <option value = "<?php echo $result['productname']?>"><?php echo $result['productname']?></option>