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 die(mysql_error()); $query = "SELECT * FROM temp_table"; $result = mysql_query($query,$db2) or die(mysql_error()); I get error that temp_table doesn't exist on db2 How can it be possible to use it on db2 queries ? Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
