mysql_fetch_array取值_用my_fetch_array()从数组结果中提取信息。

$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 "

do

{

echo "

";

echo "

".$info[bookname]."".

$info[bookid]."

".$info[date]."".$info[author]."";

echo "

";

}while($info=mysql_fetch_array($result));

echo "

";

?>