我试图显示从newproduct mysql表到组合框的productname.下面的代码正在执行，但显示为空白 - i am trying to display productname from newproduct mysql table into combobox. The following code is executing but its displaying a blank

i am trying to display productname from newproduct mysql table into combobox. The following code is executing but its displaying a blank

**<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>

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

使用mysql_fetch_array()更改获取记录

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

试试这个

<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>

try this:

<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>

while循环在第一个<?php ... ?>代码段中完全执行。while循环使用的语法不会跨多个php代码段执行。

试着回显你的选项HTML代码，这样只有一个php代码片段。

<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)) {
      echo '<option value = "',  $result['productname'], '">', $result['productname'], '</option>';
    }
  ?>