看好多资料都有类似下面的例子,我建立了一个php文件:
<?php
    $db=mysql_connect("127.0.0.1","root","adsg");
    mysql_select_db("tcrm");
    $r = mysql_query("select * from dept");
    echo $r->num_rows;
?>
数据连接访问都没有问题,可就是echo  $r->num_rows;报告错误:
Notice: Trying to get property of non-object in E:\PHPnow-1.5.1\vhosts\xxh.com\Hello.php on line 5
用mysql_num_rows($r)则没有问题。
后来测试:

<?php
    $db= new mysqli("127.0.0.1","root","adsg","tcrm");
    $r = mysqli_query($db,"select * from dept");
    echo $r->num_rows;
?>
发现这样使用是对的。就是说mysqli_query可以返回对象。

posted on 2009-06-15 10:30  garfieldtom  阅读(437)  评论(0编辑  收藏  举报