How to fetch the data for PHP from two databases on different hosts and put them in a single html table?
<p>I have to put the data into a php page from the databases which are in seperate hosts. The one workaround i can think of is getting the data from both the databases onto an array and then displaying it. What if the array is multi dimensional? How to merge data from two databases on two different hosts in PHP? I am using PHP5.</p>

<p>Specifics: I am working on a booking engine. There are booking pages for each state and databases for each of them on different hosts.I am working on creating a kind of summary page for staff, which shows the bookings done for all the states in a single page. They need it for internal use. The booking table in each of the database has same no.of rows. I need to know how merge the arrays obtained from these databases and then display it in a single web page.</p>
