two databases at once

viveleroi0

Is there a way to connect to two mySQL databases and run queries on tables in each at the same time?

Like connect to the database 1, table products, and also connect to database 2, table is orders.

Can that be done at the same time?

OhLordy

Have you tried this

<?
$conn1=mysql_connect($host,$user,$pass);
$conn2=mysql_connect($host,$user,$pass);

$db1=mysql_select_db($database1,$conn1);
$db2=mysql_select_db($database2,$conn2);

$result1=mysql_query($query1,$conn1);
$result2=mysql_query($query2,$conn2);
?>

I don't know if this works but try it and see.
HTH
Rob

superwormy

Yeah, just use two different connections like details in the manual...

www.php.net/mysql_query
www.php.net/mysql_select_db
www.php.net/mysql_connect
www.php.net/mysql_close

You do realize though that you can have more than one table in each database... right?

viveleroi0

Yes I do realize that... and I do have that setup. I need to have to different databases for other reasons.