大家好,我是想传个id参数;然后输出有关参数的内容;但显示错误??
不知道哪里错了,刚刚接触麻烦大家告一下。谢了!!
mysql_result函数不是读取相应字段的内容么??
<?php
$connect = mysql_pconnect("localhost","root","");
mysql_select_db($connect);
$sql = "select * from test where id=".$_GET["id"];
echo $_GET["id"];echo $sql;
$result = mysql_query($sql);
$username1= mysql_result($result,0,"username");
$id1 = mysql_result($result,0,"id");
$password1 = mysql_result($result,0,"password");
$name1 = mysql_result($result,0,"name");
echo "ID:$id1,用户名:$username1,";
echo "密码:$password1,真名:$name1<br>";
mysql_close($connect);
?>
===错误信息
1select * from test where id=1
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in d:\usr\www\html\phpexe\display.php on line 7
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in d:\usr\www\html\phpexe\display.php on line 8
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in d:\usr\www\html\phpexe\display.php on line 9
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in d:\usr\www\html\phpexe\display.php on line 10
ID:,用户名:,密码:,真名: