//$str=str_replace(" ","%"," $_POST[search_name] "); $sql="select * from guestbook where content like '%$_POST[search_name]%'order by id"; $result=mysql_query( $sql); $search_sum=mysql_num_rows($result); echo"$search_sum"; //while($array=mysql_fetch_array($sql))怎么不行啊,
order 是不是与前面的粘在一起了?没有空格隔开吗?
是怎么个不行法?出错还是找不到结果?用这看看.$sql="select * from guestbook where binary content like '%".$_POST['search_name']."%' order by id";
select * from 表 where 字段 like '%关键词%'
$sql="select * from guestbook where content like '%$_POST[search_name]%'order by id";
$result=mysql_query( $sql);
$search_sum=mysql_num_rows($result);
echo"$search_sum";
//while($array=mysql_fetch_array($sql))怎么不行啊,
$sql="select................";
$result=mysql_query($sql); //*
$num=mysql_num_rows(result); while($array=mysql_fetch_array($sql))//*
{......}报错:有*的两行有错
什么原因呢?
while($array=mysql_fetch_array($sql))
应该为
while($array=mysql_fetch_array($result))
第一个估计是连接数据库出错吧,你把错误信息写出来
while($array=mysql_fetch_array($result)) 这行肯定报错有可能是你的$sql就出错了
或者连接数据库,选择数据库的错误