mysql_fetch_array() warning when moving code

dziman1229

I am transfering my php script from one machine to another. The script worked perfectly fine on the first machine, but when I uploaded it my other machine I got this error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/apache2/htdocs/joblog.php on line 71

The first machine was running php version 4.2.3

The second is running 4.2.2

Is this possibly a configuration problem?

rubric

You have to make sure the database(s), or at least the table(s), on both computers are EXACTLY IDENTICAL. I use my machine at home to program for a remote server, and I used to get errors like that because I'd forget to make the new changes on the server-side database.

Also, sometimes it has something to do with quotes. If you have a query that includes a php variable in it, it might have quotes in it that offset the code. There is an option called magic quotes in the php.ini file that sometimes takes care of that problem for you and maybe the option is turned on for the original computer but not for the other. I don't mess around with magic quotes; I like to use the addSlashes() function. If you're not familiar with any of this, search for it in this site.

If everything is exactly identical and the quotes are not the problem, try to find which mysql result is causing the error and post the query for us to dissect.

Hope this helps.

Rubric

hand

Before you execute the
mysql_fetch_array()
I'm sure you are executing mysql_query()

Please add there an OR Statement to get further informations (mysql error and error code)

mysql_query($query)
   or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

(Are you sure that the connect string (hostname, userid, password, port) is correct?)