很奇怪的PHP错误提示。
我下面的代码如果在function里面就会出现“Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in D:\html\php\bbs\def.php on line 33”错误。
错误句子是:$data1=mysql_query($sql_1,$conn) or die(mysql_error());
但是假如我把function定义的VIEWTOP1 给去掉,内容就能正常显示了。。。完整代码如下
=============代码===========================
<?
$cn_server="localhost";
$cn_user="root";
$cn_password="passowrd";
$cn_database="bbs";
//====================表结构============================
$users="bbs_user"; //用户表
$top1 = "bbs_top1"; //标题栏目
//=======================================================
$conn=mysql_connect($cn_server,$cn_user,$cn_password)or die("不能连接到服务器上的数据库");
mysql_select_db($cn_database) or die( "不能连接到相应的数据库");
function viewtop1() {
$sql_1="select * from ".$top1." where iid=0";
$data1=mysql_query($sql_1,$conn) or die(mysql_error());
$num1=mysql_num_rows($data1);
if ($num1==0) {
mysql_close($conn);
mysql_free_result($data1);
exit;
} else {
for ($si=0; $si<$num1; $si++) {
$rs=mysql_fetch_array($data1);
$value1 = $value1 . "<li>" . $rs["object"] . "</li>";
}
mysql_free_result($data1);
}
echo "<ul>". $value1 . "</ul>";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<link href="include/sytle.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="header">
<? viewtop1(); ?></div>
<div id="contain">
<div id="mainbg">
<div id="right">
<div
class="text">
<p> </p>
</div>
</div>
<div id="left">
<div class="text"></div>
</div>
</div>
</div>
<div id="footer">
<p> </p></div>
</body>
</html>