大家好!我用自己的电脑做服务器,安装了appserv ,初学,写了个留言本,留言可以传资料到phpmyadmin里了,但我想使用以下代码把所有资料显示出来,却显示如下错误:Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in F:\appserv\www\show.php on line 19Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in F:\appserv\www\show.php on line 23
我的代码是:
<?
$mysql_server_name = 'localhost';
$mysql_username = 'root'; //你的mysql用户名
$mysql_password = 'jm1230456'; //你的mysql密码
$mysql_database = 'jm'; //你的mysql库名
$sql="select*from 'ly'";
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$result=mysql_db_query($mysql_database,$sql,$conn);while($row=mysql_fetch_row($result))
{
print_r($row);
}
mysql_free_result($result);
?>哪位热心人帮帮我啊!
我的代码是:
<?
$mysql_server_name = 'localhost';
$mysql_username = 'root'; //你的mysql用户名
$mysql_password = 'jm1230456'; //你的mysql密码
$mysql_database = 'jm'; //你的mysql库名
$sql="select*from 'ly'";
$conn = mysql_connect($mysql_server_name,$mysql_username,$mysql_password);
$result=mysql_db_query($mysql_database,$sql,$conn);while($row=mysql_fetch_row($result))
{
print_r($row);
}
mysql_free_result($result);
?>哪位热心人帮帮我啊!
改成
$sql="select * from ly";
or
mysql_query("set names utf8");
2、乱码问题请指定编码
ly是表名吧干嘛用单引号呢?
$sql="select*from ly";
或
$sql="select*from `ly`";