Hi,

I need to add the result of 4 calls to mysql_query (4 different queries) to the same object so that i can mysql_fetch_object in the same loop.

Is that possible? otherwise is there any other alternative?

Thank you


__________________________________________________ __________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i...Dypao8Wcj9tAcJ

It Maq wrote:
> Hi,
>
> I need to add the result of 4 calls to mysql_query (4 different queries) to the same object so that i can mysql_fetch_object in the same loop.
>
> Is that possible? otherwise is there any other alternative?
>
> Thank you
>
>
> __________________________________________________ __________________________________
> Be a better friend, newshound, and
> know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i...Dypao8Wcj9tAcJ
>

use a UNION (look it up in the mysql manual)

On 6 May 2008, at 15:05, It Maq wrote:
> I need to add the result of 4 calls to mysql_query (4 different
> queries) to the same object so that i can mysql_fetch_object in the
> same loop.
>
> Is that possible? otherwise is there any other alternative?

No, but you should be able to do it in one query...

http://dev.mysql.com/doc/refman/5.0/en/union.html

-Stut

--
http://stut.net/