Posted by cseymour on 10/04/06 20:45

Hi Daz,
Are the data being return from the 2 queries similar? Have you looked
into using a UNION?

For example:

select ID_add 'Field1', ID_tpl 'Field2', null 'Field3', null 'Field4'
from address_add
Union
select null 'Field1', null 'Field2', ID_brd 'Field3', ID_per 'Field4'
from boardmembers_brd


Just a thought.

Chris


Daz wrote:
> 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

• Next in forum: Re: Makeing multiple MySQL queries in a single query.
• Prev in forum: Makeing multiple MySQL queries in a single query.
• Thread view: Re: Makeing multiple MySQL queries in a single query.

[Reply to this message]