读懂报错 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in G:\wam\.....
来源:互联网 发布:淘宝运营怎么做 编辑:程序博客网 时间:2024/06/01 21:54
错误截图
报错源代码
<?php require("header.php"); $sql = "SELECT entries.*, catetogries.cat FROM entries, catetogries WHERE entries.cat_id = catetogries.id ORDER BY dateposted DESC LIMIT 1;"; $result = mysql_query($sql); $row = mysql_fetch_assoc($result); echo "<h2><a href='viewentry.php?id=".$row['id']."'>".$row['subject']."</a></h2><br />"; echo "<i>In <a href='viewcat.php?id=".$row['cat_id']."'>".$row['cat']."</a> - Posted on ".date("D js F Y g.iA",strtotime($row['dateposted']))."</i>"; echo "<p>"; echo nl2br($row['body']); echo "</p>"; require("footer.php"); ?>
指mysql_fetch_assoc()需要一个参数句柄作为源,但是这个传进来的是一个布尔值,即没读取到数据
即:
sql语句出错!!!
查询了下sql数据库,发现数据表名字是catetories,而并非catetogries,修改后即可读取数据
0 0
- 读懂报错 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in G:\wam\.....
- Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /***
- Warning:mysql_num_rows() expects parameter 1 to be resource,boolean given in F:.....\db_func.php onl
- Warning: mysql_fetch_assoc() expects parameter 1 to be resource解决方法
- php访问数据库出错:Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given i
- 关于warning: mysql_result() expects parameter 1 to be resource,object given in……的解决方法
- Warning:mysql_fetch_assoc() expects paramet 1 to be resource问题解决
- ecshop出现 readdir() expects parameter 1 to be resource, boolean given 错误
- MySQL mysql_fetch_array() expects parameter 1 to be resource报错
- Magento Warning: PDO::quote() expects parameter 1 to be string, object given in
- Warning: number_format() expects parameter 1 to be double, string given in
- Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /var/www/html/php..解决方案
- Warning: flock() expects parameter 1 to be resource
- PHP Warning: mysql_num_rows() expects parameter 1 to be resource
- Warning: mysql_query() expects parameter 2 tobe resource, object given i
- Warning: mysqli_fetch_array() expects parameter 2 to be integer, string given……解决方案
- 编程过程中Notice: Use of undefined constant XXXX和Warning:expects parameter 1 to be resource...
- token 6.x-1.17 "preg_match_all() expects parameter 2 to be string, array given in token_scan()" 问题解决
- 嵌入式linux:ubuntu Linux离线安装软件包
- 敏捷开发之Scrum扫盲篇
- Session和DAO 用户登陆
- IOC
- STM32:STM32库函数配置
- 读懂报错 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in G:\wam\.....
- Git 命令学习小笔记
- codeforces GoodBye2015 D.New Year and Ancient Prophecy (dp+lcp+树状数组)
- 安卓移动浏览器开源项目优分享浏览器的介绍
- ArcGIS Engine 开发中一些常用的语句
- STM32:keil的软件逻辑分析仪( logic analyzer)使用
- System.Web.Optimization找不到引用
- C/C++基础知识(一)数组和指针
- android学习笔记——收发短信练习