?
Solved

php warning: mysql_fetch_row()

Posted on 2014-12-01
7
Medium Priority
?
171 Views
Last Modified: 2014-12-01
I have no idea if someone can help me with this or not but since my programmer is gone for 24hrs, I need to ask someone.

I am seeing the following error in the apache logs;

PHP Warning:  mysql_fetch_row() expects parameter 1 to be resource, string given in app.php on line 103

Line 103 is;

$select = mysql_fetch_row($query);
0
Comment
Question by:projects
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 36

Accepted Solution

by:
Loganathan Natarajan earned 500 total points
ID: 40474193
Check before this line whether you've execute the query with result. Example,
0
 

Author Comment

by:projects
ID: 40474199
The line before that is;

$result = execQuery($dbconn,$query);

Your example link doesn't seem to lead to anything.
0
 
LVL 58

Assisted Solution

by:Gary
Gary earned 1000 total points
ID: 40474208
Means the query failed so there are no rows to fetch
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 

Author Comment

by:projects
ID: 40474215
So it's just a warning, nothing to be concerned about? Or, does it possibly mean it is not finding the data?
0
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 500 total points
ID: 40474217
0
 

Author Comment

by:projects
ID: 40474222
Ok, so it looks like the programmer just missed this because everything else is using mysqli.
He just needs to update this then.
0
 
LVL 58

Assisted Solution

by:Gary
Gary earned 1000 total points
ID: 40474225
Not really a warning, when executing the query something went wrong i.e. your sql is wrong
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this article, we’ll look at how to deploy ProxySQL.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question