我试图从数据库中创建我的产品类型的下拉列表,我使用这个代码从如何填充HTML下拉列表与值从数据库
<select name="product_type">
<?php
include('include/conn.php');
$sql = mysql_query("SELECT product_type FROM produk2");
while ($row = mysql_fetch_array($sql)){
echo "<option value='"product_type1'">" . $row['product_type'] . "</option>";
}
?>
</select>
我要把这个添加到我的搜索引擎中,但是代码的下拉菜单使它从product_type读取所有数据。是否有可能在没有相同的product_type两次创建下拉菜单?
你至少应该使用mysqli:
conn.php =
$con=mysqli_connect("server","username","password","database");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
然后你的查询文件:
<select name="product_type">
<?php
include('include/conn.php');
$sql = mysqli_query($con,"SELECT product_type FROM produk2 GROUP BY product_type")
while ($row = mysqli_fetch_array($sql)){
echo "<option value='"product_type1'">" . $row['product_type'] . "</option>";
}
?>
</select>