Jump to content

mysql_fetch_row() warning


BigMonkey

Recommended Posts

This warning/error started about 2 days ago.  Only one change has occurred on the server, and that is a change in the password.  The script should fail long before it get to its current failure point if the password were the issue.

 

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$dbname = 'nameofdb';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
mysql_select_db($dbname, $conn) or die('Error selecting DB.');
$query  = "SELECT * FROM news_items";
$result = mysql_query($query, $conn) || die('Failed Query');

// Following line gives error "Warning...supplied argument is not a valid MySQL result resource..."
print_r(mysql_fetch_row($result));
?>

 

I started with an only slightly more complex query and reduced its complexity until I had what is here.  I verified that the script:

*  fails to connect to db if the password is changed to be incorrect,

*  fails to select the db if the name of the db is changed to be incorrect, and

*  fails to query the db if syntax errors are introduced into the query string.

 

I have restarted the services hoping that might help, but it did not.

 

Versions:

WAMP5: Apache 2.2.6, MySQL 5.0.45, PHP 5.2.5

 

I have queried a number of time in the past without incident, so I'm confident that there error is something small, overlooked coding error or something.

 

The error seems to indicate that there is something wrong with the query, but I don't see it.  In case it matters, there *is* data in the database, so there is actually something to query.  Does anything stand out for you?

 

Thanks!

 

Link to comment
Share on other sites

Thanks!

 

|| is not the same as 'or'

 

That fixed it.  I don't know why I thought is was the same, but I'll be reading about that more.

 

You also shouldn't handle errors that way.  Read more here:

 

http://www.phpfreaks.com/blog/or-die-must-die

 

I will also be reading about this. 

 

Thank you for the BRIEF responses without the clutter of unnecessarily technical details.

Link to comment
Share on other sites

Thanks!

 

|| is not the same as 'or'

 

That fixed it.  I don't know why I thought is was the same, but I'll reading about that more.

 

You also shouldn't handle errors that way.  Read more here:

 

http://www.phpfreaks.com/blog/or-die-must-die

 

I will also be reading about this. 

 

Thank you for the BRIEF responses with the clutter of unnecessarily technical details.

 

You possibly thought it was the same because in some scripting languages || means or.

Link to comment
Share on other sites

You possibly thought it was the same because in some scripting languages || means or.

 

Probably, but at least I should be consistent about it, right!?  :)

 

yh i guess lol. untill i read this thread i didnt see it as a problem in your code cos on of the scripting languages i know uses it.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.