Question

如何用PHP获取数据库表一列的所有数据显示在下拉菜单中，如下我的代码报错，怎样解决？

<select>
<option value=0>请选择</option>
<?php
try{
$pdo = new PDO('mysql:host=localhost;dbname=school',"root","");
error_Log('hi, connected to my database.');
}catch (PDOException $e) {
die('connection failed'.$e->getMessage());
}
$pdo->query("SET NAMES 'UTF8'");
$search_course = "select dname from school";
$result = mysql_query($search_course, $pdo) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
echo "<option value='$row[dname]'>$row[dname]</option>";
}
?>
</select>

Answer 1

错误呢？？？？？？？？？？？？？？？？？？？？

追问

我已经解决了 谢谢