Solved

php warning: mysql_fetch_row()

Posted on 2014-12-01
7
167 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 125 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 250 total points
ID: 40474208
Means the query failed so there are no rows to fetch
0
Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

 

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 125 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 250 total points
ID: 40474225
Not really a warning, when executing the query something went wrong i.e. your sql is wrong
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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.
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

717 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