用my_fetch_array()从数组结果中提取信息。
<div align="center">
<form action="" method="post">
<input type="text" name="text">
<input type="submit" value="submit" name="submit">
</form>
</div>
<?php
$bookname=$_POST['text'];
$link=mysql_connect("localhost","root","111111") or die("Can't connect database!".mysql_error());
$selected=mysql_select_db("test",$link);
mysql_query("set names gb2312");
$result=mysql_query("select * from book",$link);
$info=mysql_fetch_array($result);
if($_POST['submit']=='submit')
{
$result=mysql_query("select * from book where bookname like '%".trim($bookname)."%'",$link);
$info=mysql_fetch_array($result);
}
echo "<div align=\"center\"><table cellpadding=0 border=1 bgcolor=\"#FFFCCC\">";
do
{
echo "<tr>";
echo "<td>".$info[bookname]."</td><td>".
$info[bookid]."</td><td>".$info[date]."</td><td>".$info[author]."</td>";
echo "</tr>";
}while($info=mysql_fetch_array($result));
echo "</table></div>";
?>