PHP MYSQL

$dsql = "SELECT comp_id FROM `match` WHERE prod_id=346";//.$row['prod_id'];
$dresult = $db->query($dsql);
$drow = $dresult->fetch_array();
print_r($drow);


SQL在 phpMyAdmin 运行没有错误并且得出两条记录,但是打印不出来两条记录,我想取comp_id,

高手们帮看看 谢谢了

PHP code

<?php
$con = mysql_connect("localhost", "hello", "321");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

$db_selected = mysql_select_db("test_db",$con);
$sql = "SELECT * from Person WHERE Lastname='Adams'";
$result = mysql_query($sql,$con);
print_r(mysql_fetch_array($result));

mysql_close($con);
?>

// 发个例子你看看
// 用完数据库记得关闭连接