Posted by ZeldorBlat on 08/21/07 00:29

On Aug 20, 5:32 pm, Vik Rubenfeld <v...@mindspring.com.invalid> wrote:
> I have to search 2 mySQL tables, and show the user a single sorted list
> that contains all the results from both mySQL queries.
>
> My question is, how do you get all the resulting items from both
> databases into one single, sorted list, to present to the user?
>
> I guess one way would be, to use PHP to copy all the results from each
> database, into a PHP array, and then sort it. Is that how this kind of
> thing is usually done?
>
> Thanks in advance to all for any info.

Use union:

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

[Back to original message]