Posted by Daz on 10/04/06 20:29

Hi. I am trying to select data from two separate MySQL tables, where I
cannot use join, but when I put the two select queries into a single
query, I get an error telling me to check my syntax. Both of the
queries work fine when I use them to query the MySQL server directly.

My guess is that the MySQL extension only expects a single resource
back from the database, but get's several, or that it just checks the
statement first, and decides it's not valid. However, my guesses and/or
assumptions don't really make much of a difference as to the workings
of the PHP MySQL extension.

Would anyone know if there is something I can do to get around this
problem?

Any input would be appreciated.

Thanks.

Daz

[Back to original message]