|
|
Posted by Daz on 10/06/06 01:33
cseymour wrote:
> Hi Daz,
> Couldn't you create a PHP function that would fire all your queries
> then return the results as an array, kind of like createing the "array
> of arrays" you had mentioned?
>
> Just a thought.
>
> Good luck. I'll keep chewing on this one for a bit.
>
> Chris
> Daz wrote:
> > 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.
Hi Chris,
Thanks for your input. My objective is to reduce the number of separate
queries made to the database at any one time. I think the only way that
this is ever going to be possible, is if they change the way that the
MySQL extension for PHP works. I think it's fairly safe to say that
there aren't many people quite pedantic about such small details as I
am, although I am sure there are a few in their minority.
Thanks for sharing your thoughts.
All the best.
Daz
Navigation:
[Reply to this message]
|