Question

一段php怎么出错了 郁闷

<?PHP
$conn=mysql_connect("localhost","root","1234") or die("数据库连接失败").mysql_error();
mysql_select_db("guestbook") or die("数据库选择失败");
mysql_query("set names utf-8");
$sql=mysql_query("insert into test(ming,sex)values('whi','nan')");
mysql_free_result($sql);
mysql_close($conn);
?>
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\inetpub\wwwroot\php\my\conn.php on line 6

Answer 1

insert 语句返回的不是 MYSQL资源

追问

还是出错啊

追答

把数据库连接和数据库名改成你自己的.

Answer 2

哪里报错？？

追问

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\inetpub\wwwroot\php\my\conn.php on line 6

追答

$conn = mysql_connect("localhost","root","1234");
if (!$conn)
{
die('Could not connect: ' . mysql_error());
}
改成这样呢？

追问

数据库连接正确，是关闭记录集出错

追答

mysql_query("set names utf8");

Answer 3

mysql_free_result(): 改为 mysql_result():

Answer 4

values和前面的“）”有空格吗