Posted by Vik Rubenfeld on 08/20/07 21:32

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.

• Next in forum: Re: question mark in serialized object
• Prev in forum: Re: Any ideas how to read a url that's changed by the server?
• Thread view: Best Way to Combine Results from 2 mySQL Searches, into One Sorted List?

[Reply to this message]