Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > mysql异常，

mysql异常，

WBOY
Release： 2016-06-13 13:36:10
Original
918 people have browsed it

mysql错误，急！
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in D:\wamp1\www\empmanage\empMain.php on line 37
   
大致代码如下
  $sql="select * from emp limit".($pageNow-1)*$pageSize.",$pageSize";
  $res2=mysql_query($sql,$conn);
37行 while($row=mysql_fetch_assoc($res2)){
echo "

{$row['id']} {$row['name']} {$row['grade']}".
"{$row['email']} {$row['salary']}".
"删除用户 修改用户 ";
}
echo "";
解释下这句话是什么原因。

------解决方案--------------------
意思是36返回的不是resource而是boolen的false
36行改成 $res2=mysql_query($sql,$conn) or die(mysql_error());
看输出什么？
Related labels：
gt lt mysql quot
source：php.cn
Previous article： $_FILES["file"]["size"] 结果单位疑问解决办法 Next article： $_SERVER[HTTP_HOST]要如何样调用才能有效
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1429
PX automatic conversion to REM error  <style>html {   font-size: calc(100vw / 3.75);      }...
From 2024-04-16 09:34:16
0
0
4687
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
How to trigger render (with filter and pagination) on sort method in React? Here is my Sort.js style component: <SortWrapper><SortText>SortBy</SortText...
From 2024-04-06 21:28:37
0
1
2257
Dynamically modify inline CSS styles in Javafx I'm trying to change the background image of a pane when the application is maximized. My ...
From 2024-04-06 20:57:16
0
1
487
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template