Weird SQL query problem

Anon

I have this SQL query :

select A.Name, B.Age from A inner join B on A.ID=B.ID

.. on two MySQL DB tables namely A and B. But it results in a "Warning: Supplied argument is not a valid MySQL result resource in ... " message.

What's wrong with the above SQL query syntax. Any help is appreciated!

Anon

Nothing, probably. You're not connected to the MySQL database.

Anon

The connection to the DB is there and infact, if I replace the mentioned query with a simpler query like "select * from A" then it works. Wonder what's going on?

Anon

Well, I wonder that too since the error :

"Warning: Supplied argument is not a valid
MySQL result resource in ... "

.. indicates that the connection isn't there. Perhaps the query is crashing the backend?

Anon

No, Mitch, it means that a result index passed to a mysql result set parsing function isn't valid, usually caused by a result index=0 (which CAN be caused by a bad connection or any of a number of other reasons).

ASHBEN,

Post the code you are using that is causing the problem.

Try putting
print mysql_error();
after the query execution.

Anon

Apparently I figured out the problem. I'm using MySQL 3.22 on the production server and the build does not support INNER JOINS. So my sql query results in an invalid recordset id or whatever and that's why the warning. A variation of the query by giving away the JOIN worked too.