how to connect 2 databases simlutaneously using php

[neovantage]

Hey,
I want to connect to 2 different MYSQL databases at the same time. Does somebody help me out that how can i do that closing one connection and selecting other and vice versa...?


kind regards,
Mohsin Rafique

[Atli]

Hey.

If you are using the old MySQL extension, then all you would have to do is retrieve the return value of the mysql_connect function and use that value with the other mysql_ functions.

[code=php]<?php
$db1 = mysql_connect(' host1', 'usr', 'pwd');
$db2 = mysql_connect(' host2', 'usr', 'pwd');

mysql_select_db ('dbName', $db1);
mysql_select_db ('dbName', $db2);

mysql_query($sq l, $db1);
mysql_query($sq l, $db2);
?>[/code]

[dlite922]

Then one might ask: what if you want to join two tables from two databases together?

easy, MySQL query allows you to select which database a table is from by appending the database number, a dot, and then the table name like so: db1.my_table JOIN db2.second_tabl e.


Food for thought,



Dan