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

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

Hi Chris.

Thanks for your input. Unfortunately, UNION will not work for what I
need it for. I need to get the data from several different tables for
different users. I was forced into breaking everything up into separate
tables due to the MySQL restrictions and in the interest of keeping the
data optimized and the database query response times fast. As a result,
the number of colums is different for each of the 26 tables (ranging
from 6 columns, to 530 columns). It could just be a flaw in my design,
however, it would be fantastic to be able to put lots of SELECT queries
together into a single query, and get all of the results back in the
form of an array of arrays.

Thanks again.

[Back to original message]