欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

mysql_fetch_array(): supplied argument is not a valid MySQL result resource

程序员文章站 2022-05-10 18:54:27
...
php 无效sql结果资源 mysql




江苏农二代农林生态发展有限公司



include "conn/conn.php";

?>
?>








mysql_fetch_array(): supplied argument is not a valid MySQL result resource















































新闻中心 News





公司新闻





行业咨询





技术问答





成功案例





客户评价





公司服务






if($_GET['identification'] != null){
$sql = mysql_query("select * from frontpagenews where identification = ".$_GET['identification']."order by createDate desc limit 0,7");
这里报错 while($result = mysql_fetch_array($sql)){
?>






}
}else{

$sql = mysql_query("select * from frontpagenews where identification = 1 order by createDate desc limit 0,7");
while($result = mysql_fetch_array($sql)){
?>





}
}
?>










新闻中心 您现在位置:首页 > 新闻中心
mysql_fetch_array(): supplied argument is not a valid MySQL result resource
mysql_fetch_array(): supplied argument is not a valid MySQL result resource






错误信息

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Apache\htdocs\growers\news.php on line 147

回复讨论(解决方案)

$sql = mysql_query("select * from frontpagenews where identification = ".$_GET['identification']." order by createDate desc limit 0,7");

mysql_query("select * from frontpagenews where identification = ".$_GET['identification']. "order by createDate desc limit 0,7");
除非 $_GET['identification'] 最后的字符是空格,不然 $_GET['identification'] 的值不就和 order 连在一起了?
如果 $_GET['identification'] = 1
你的 sql指令不就了
"select * from frontpagenews where identification = 1order by createDate desc limit 0,7"
吗?

粗心要人命啊。多谢了。少个空格

mysql_fetch_array(): supplied argument is not a valid MySQL result resource

声明:本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn核实处理。

相关文章

相关视频