On Fri, Jun 6, 2008 at 9:25 PM, TUT - LightSpeed <[EMAIL PROTECTED]> wrote:
>
> Actually they are 2 connection to 2 different databases on 2 different
> hosts.
> I wanted rquery results from db1 to be in a temporary table to be used in
> db2.
> I can go around it with some php code to create the t
de to create the table in db2 but thought
it could be easier just to use the temporary table created by the query on
db1.
Thanks
--
From: "Omni Adams" <[EMAIL PROTECTED]>
Sent: Friday, June 06, 2008 7:32 PM
To:
Subject: Re: T
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 that temp_table
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_err
