MySQL result index: This is a good one!!

[Anon]

I have two virtual sites on the same server.
Several of the sites access the same database with the same code.

One of the sites is having problems though.
Every single one of the Mysql selects returns the dreaded

"Supplied argument is not a valid MySQL result resource".

I can't understand it! The exact same code, and the virtual host can connect up with the database no problems via ssh - but even the simplest select statement to this database and it chokes.

I have checked the MYSQL database privileges for this Virtual host to access the database and it is set up correctly.

I'm at a loss here - has anyone else ever had problems like this??

Thanks for any ideas or help you can give.

Webby!

[Anon]

That error indicates that the query failed for some reason. Use mysql_error() immediately after issuing the query to see what MySQL is complaining about.

Any attempt to address what is wrong without knowing the exact error MySQL returned would be speculation.

[Anon]

Hi Rod,

Thanks for the tip. 🙂

echo mysql_error(); directly after the query

I suspected that there may have been existing open connections to Mysql in the header file to another database that have not been closed.

True True!! Somewhere in the header file there is an open connection to the other database.

Table 'mydatabase2.tablename' doesn't exist
Warning

Thanks Rod, I appreciate that.

Maeve