You could do this: Build a sql statement, then connect to each of the servers and save the results in a variable, $result_1 $result_2 .... Then do: $result_all = array_merge($result_1,$result_2,...) The result sets have to have identical layouts, though. Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 "Pay It Forward!" -----Original Message----- From: Seth Bembeneck [mailto:sbdataspiller@xxxxxxxxxxxxx] Sent: Friday, May 07, 2004 12:09 AM To: php-db@xxxxxxxxxxxxx Subject: merging a table from multiple servers I'm trying to work on a project that gathers info from different servers, then combines them and displays it. Is it possble to merge the tables from the different servers into 1 table using php? My one solution to this was to have a php script on each server, then have my website call each php script, retrieve the info then insert it into my database. For a glimps of the amount of data I'm trying to merge: http://cwhq.net/index.php?action=stats&mod=kill_stats_totals Now imagine 10 different servers with similer data. I'm trying to provide a way for Deltaforce Gamers to see their stat from all the game servers that collect the stats in 1 location. Thanks, Seth -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
