Easy Question

[MFKR]

I was curious is it possible to have multiple database connections in 1 config file? like lets say this:

$host = "host";
$user = "username";
$pass = "password";
$db = "database";
$table = "mfkr_table1";
mysql_connect($host,$user,$pass) or die("Cannot connect to mysql server");
mysql_select_db($db) or die("Cannot select database from mysql server");

//then have it do another

$host = "host";
$user = "username";
$pass = "password";
$db = "database";
$table = "mfkr_table2";
mysql_connect($host,$user,$pass) or die("Cannot connect to mysql server");
mysql_select_db(db) or die("Cannot select database from mysql server");

Can this work or do the $variables need to be different for each table connection?

[mrhappiness]

this works as long as you pass the return value of mysql_connect to mysql_select_db and mysql_query

$con1=mysql_connect('connection data');
$con2=myqsql_connect('connection data2');
mysql_select_db('fu', $con1);
mysql_select_db('bar', $con2);

but if it's only different databases and not different mysql-servers you should be able to do like this:

$sql='SELECT
  a.user_id, a.user_name,
  b.someotherstuff
FROM 
  database1.usertable a
  INNER JOIN database2.stufftable b
    USING(user_id)';

[rpanning]

More than likely you'll need different variable names unless you're done with the first connection BEFORE you set the next. I would just recommend using different variable names, it'll work the best. Try using arrays like this.

$host[0]  = "host"; 
$user[0]  = "username"; 
$pass[0]  = "password"; 
$db[0]    = "database"; 
$table[0] = "mfkr_table1"; 
mysql_connect($host[0],$user[0],$pass[0]) or die("Cannot connect to mysql server"); 
mysql_select_db($db[0]) or die("Cannot select database from mysql server"); 

//then have it do another 

$host[1]  = "host"; 
$user[1]  = "username"; 
$pass[1]  = "password"; 
$db[1]    = "database"; 
$table[1] = "mfkr_table2"; 
mysql_connect($host[1],$user[1],$pass[1]) or die("Cannot connect to mysql server"); 
mysql_select_db($db[1]) or die("Cannot select database from mysql server");