$query="select *from library where" .$name." like '%".$bookname."%'";
这段好像不对吧
改成:
$query="select * from library where name like '%$bookname%'";
//name 为要查找的字段名
这段好像不对吧
改成:
$query="select * from library where name like '%$bookname%'";
//name 为要查找的字段名
-------------------------
if ($rownumber!=0)
改为:
if ($rownumber)
-------------------------这段:
-------------------------
if($rownumber==0)
改为:else
----------------------------------------------
错了,
$result=mysql_query($query,$con);
改成:
$query="select * from library where $name like '%".$bookname."%'";
出错:
$query="select *from library where " .$name." like '%".$bookname."%'";
改为:
$query="select * from library where name like '%$bookname%'"; //name 字段 或:
$query="select * from library where $name like '%$bookname%'"; //$name变量
2、$result=mysql_query("query",$con); 改成:
$result=mysql_query($query);
$query="select *from library where" .$name." like '%".$bookname."%'";这句问题可能最大了,
改成
$query="select * from library where " .$name." like '%".$bookname."%'";
也不行,我看了很多书都是这样写的啊,
如果你用的是php4以上的版本,$bookname是通过表单来传递的话,你应该改成 $_POST[bookname]
<?php
$con=mysql_connect("localhost","root","");
mysql_select_db("tushu");
$query="select * from library where name like '%$bookname%'";
$result=mysql_query($query,$con);
$rownumber=mysql_num_rows($result);
if($rownumber)
{
echo "<cneter>";
echo "<table border='1'><td>";
echo "<tr>";
echo "<td align=center>".$id."</td>";
echo "<td align=center>".$name."</td>";
echo "<td align=center>".$author."</td>";
echo "<td align=center>".$classname."</td>";
echo "<td align=center>".$edtidate."</td>";
echo "</tr>";
while ($r=mysql_fetch_array($result))
{
$name=$r["name"];
$author=$r["author"];
$id=$r["id"];
$classname=$r["classname"];
$editdate=$r["editdate"];
echo "<tr>";
echo "<td align='left'><font size='2'>".$name."</font></td>";
echo "<td align='left'><font size='2'>".$author."</font></td>";
echo "<td align='left'><font size='2'>".$id."</font></td>";
echo "<td align='left'><font size='2'>".$classname."</font></td>";
echo "<td align='left'><font size='2'>".$editdate."</font></td>";
echo "</th>";
}
echo "</table>";
echo "</table>";
}
else
{
echo "<font face='隶书' size='5'>很抱歉,没有您需要的图书</font>";
}
mysql_close($con);
?>