刚学mysql超级菜鸟,数据库3个字段id,title,content,里面有一条内容-----------------------------------------------------------------------------idtitlecontent1韩海警用橡皮...
刚学mysql超级菜鸟,数据库3个字段id,title,content,里面有一条内容
-----------------------------------------------------------------------------
id title content
1 韩海警用橡皮弹打死中国渔民 我们要以牙还牙!!!!
-----------------------------------------------------------------------------
mysql_connect('localhost','root','');
mysql_select_db('test');
mysql_query('SET NAMES gb2312');
$sql = 'SELECT `content` FROM `db_test` WHERE `title` LIKE CONVERT(_utf8 \'韩海警用橡皮弹打死中国渔民\' USING gbk) COLLATE gbk_chinese_ci';
$searchresult=mysql_query($sql);
//var_dump($searchresult); 用var_dump检查资源显示是resource(4) of type (mysql result)
while($row = mysql_fetch_array($searchresult)){
echo $row['content'];
}
?>为什么不显示内容啊??????但是通过id字段查询会显示结果,在线等
"SELECT `content` FROM `db_test` WHERE `title` LIKE '韩海警用橡皮弹打死中国渔民'"
我自己解决了,这样就可以
展开