database connect

[coolz]

Is it okay to connect and execute two diff database in one page? Will it not slow down the processing?

[bastien]

Not much...it just two calls and the associated overhead of the connection...

to calify though, is it two DBs? or two tables?

[coolz]

two DB's.

will it not cause any error even if i call a variable from the first db at the end of the page? at the same time executing insert/delete/add at the end of the page using the first database? will it still recognize them?

[bastien]

use separate connection strings for each one

        $username = "****";
        $pwd ="*****";
        $host = "localhost";
        $dbname = "test";



    //connect to db
    //$conn1=mysql_connect($host, $username, $pwd) or die ("Unable to connect to database");

    if (!($conn1=mysql_connect($host, $username, $pwd)))  {
      printf("error connecting to DB by user = $username and pwd=$pwd");
      exit;
    }
    $db1=mysql_select_db($dbname,$conn1) or die("Unable to connect to database1");

    $username2 = "root";
    $pwd2="";
    $host2 = "localhost";
    $dbname2 = "test";



    //connect to db
    //$conn2=mysql_connect($host2, $username2, $pwd2) or die ("Unable to connect to database");

    if (!($conn2=mysql_connect($host, $username, $pwd)))  {
      printf("error connecting to DB by user = $username2 and pwd=$pwd2");
      exit;
    }
    $db2=mysql_select_db($dbname2,$conn2) or die("Unable to connect to database2");

[coolz]

It show errors when i do it this way

// Connect to db 1
// Connect to db 2

switch ........

case 1
select table from db1
execute codes

case 2
select table from db2
execute codes

default
select table from db1
execute codes

// end

I think in this case, the the select statement doesn't know where to connect. How can I make the select statement connect to the rigth db?

[mrhappiness]

did you provide $conn1 respectively $conn2 to mysl_query?

if both databases may be access using the same user and the same password you can do SELECT database.table and SELECT database2.table as well