For some strange reason I am getting the following errors:

cbug

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sites/11/list.php on line 11

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sites/11/list.php on line 12
==> table(s) in cbug

Its displaying ok all databases and tables in each of them and totals of tables.

However it is also trying to list outside my database account:

mysql

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sites/list.php on line 11

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sites/list.php on line 12
==> table(s) in mysql

rgs_data

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sites/list.php on line 11

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sites/list.php on line 12
==> table(s) in rgs_data

scripts

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sites/list.php on line 11

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sites/list.php on line 12
==> table(s) in scripts

tester

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sites/list.php on line 11

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sites/list.php on line 12
==> table(s) in tester

vpopmail

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sites/list.php on line 11

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sites/list.php on line 12
==> table(s) in vpopmail

webby

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sites/list.php on line 11

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sites/list.php on line 12
==> table(s) in webby

webby_site

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sites/list.php on line 11

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/sites/list.php on line 12
==> table(s) in webby_site

Would this be a server issue?

It means your queries are failing and returning FALSE instead of a valid resource handle to a result rowset. You can use mysql_error() to get the error text from MySQL -- this should clear up (or at least shed light on) what's wrong with your queries.

  http://www.php.net/mysql_query
  http://www.php.net/mysql_error



Take care,

Nik
http://www.bigaction.org/

I always get these types of errors when my connection string is bad. Double check it very carefully.

Typically, people using mysql aren't using connection strings (unless they're using some DB wrapper class, such as PEAR DB.


Take care,

Nik
http://www.bigaction.org/