Errors on new webhost, why?

vigour

Dear forum,

I have a problem. I have built a picture database (mySQL and PHP) that have been on the internet for 2 years without any problems at all. I uploaded the same files to another webhost a couple of days ago and suddenly the code does not work. This is the type of error messages I get.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

Can someone please tell me what is going on?

djjjozsi

"another webhost"
-that mean it is another environment, another configuration, host name might change, passwords...
-wrong database name
-the mysql table does not exists

somewhere you did not change the table names in your query.
lets print the mysql_error() get to know if the table does exist.

<?php
$link = mysql_connect("localhost", "mysql_user", "mysql_password");

mysql_select_db("nonexistentdb", $link);
echo mysql_errno($link) . ": " . mysql_error($link). "\n";

mysql_select_db("kossu", $link);
mysql_query("SELECT * FROM nonexistenttable", $link);
echo mysql_errno($link) . ": " . mysql_error($link) . "\n";
?>

vigour

The problem is solved! I got a 'database not selected' message. The reason was that I had no user for the database. Everything works like it should now.

djjjozsi;10893083 wrote:
"another webhost"
-that mean it is another environment, another configuration, host name might change, passwords...
-wrong database name
-the mysql table does not exists

somewhere you did not change the table names in your query.
lets print the mysql_error() get to know if the table does exist.

<?php
$link = mysql_connect("localhost", "mysql_user", "mysql_password");

mysql_select_db("nonexistentdb", $link);
echo mysql_errno($link) . ": " . mysql_error($link). "\n";

mysql_select_db("kossu", $link);
mysql_query("SELECT * FROM nonexistenttable", $link);
echo mysql_errno($link) . ": " . mysql_error($link) . "\n";
?>

djjjozsi

sounds great.

hello.

jjozsi