Temp table on multiple connections

I have this problem I connect to 2 database servers in the same script If I create a temp table on one, won't be able on the other $db1 = db_connect1(); $db2 = db_connect2(); $query = CREATE TEMPORARY TABLE temp_table SELECT ..; $result = mysql_query($query,$db1) or

Re: Temp table on multiple connections

on multiple connections On Fri, Jun 6, 2008 at 2:28 PM, TUT - LightSpeed [EMAIL PROTECTED] wrote: I have this problem I connect to 2 database servers in the same script If I create a temp table on one, won't be able on the other $db1 = db_connect1(); $db2 = db_connect2(); I get error