显示下拉框内容，从数据库只中获取

 <form action="" method="post">
<tr><td></td><td><select id="kind" name="kind" type="text">
<option value="0">行业类型：</option>
<option value="IT行业">IT行业</option>
<option value="食品行业">食品行业</option>
<option value="家电行业">家电行业</option>
<option value="房地产行业">房地产行业</option>
<option value="化妆品行业">化妆品行业</option>
<option value="冶金行业">冶金行业</option>
<option value="手工行业">手工行业</option>
<option value="纺织行业">纺织行业</option>
</select>
</td></tr>
<tr><td><input type="submit" name="ok" value="确定"/></td><td>
 
<input type="reset" value="重置"/></td></tr></td>
       
  </TR>
 <?php
 if(isset($_POST['ok'])){
 include("../include/dbconnect.php");

 $sql = "select * from qiye where  kind='".$_POST['kind']."'";
 $rs = mysql_query($sql);

 while($row=mysql_fetch_assoc($rs)){
 ?>
 
   <tr> <TD ><?php echo $row['name'];?></TD></tr>
    
  <?php
}
}
?>