mysqli的怪问题!!
表结构:
dictid name
0001 北京
0002 上海
0003 武汉
......
$db = new mysqli('localhost','root','123456','oke');
$query ="select MAX(dictid) from `dict` where LENGTH(`dictid`)=4";
$result = $db->query($query);
$row = $result->fetch_row();
echo $row[0];
上面的语句输出正常
但是....
$c1='北京';
$db = new mysqli('localhost','root','123456','oke');
$query ="select dictid from `dict` where name='$c1'";
$result = $db->query($query);
$row = $result->fetch_row();
echo $row[0];
这样就死活报错:(
错误信息:
Fatal error: Call to a member function fetch_row() on a non-object in
是什么原因呢?请指点一下好吗?谢谢啦