RE: accessing two databases within one script

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Of course you can

$whatever_db_linkid = mysql_connect($connectiondetails_for_whatever_db);
if(is_resource($whatever_db_linkid)) { mysql_select_db('whatever_db',
$whatever_db_linkid); }

$someother_db_linkid = mysql_connect($connectiondetails_for_someother_db);
if(is_resource($someother_db_linkid)) { mysql_select_db('someother_db',
$someother_db_linkid); }

// work your magic..



mysql_close($whatever_db_linkid);
mysql_close($someother_db_linkid);

-----Original Message-----
From: Gary Rachel [mailto:gcrachel@xxxxxxxxxxx] 
Sent: den 5 oktober 2004 04:31
To: php-db@xxxxxxxxxxxxx
Subject:  accessing two databases within one script

I have a page where I need to access two different databases in mysql.  
After accessing the first database I used  mysql_close($connection);
and then code to access the other database.  The first database access 
works fine, the second gives me the following error message:

*Warning*: mysql_query(): Can't connect to local MySQL server through 
socket '/tmp/mysql.sock'

I've tried not using the mysql_close statement.  But that option doesn't 
select the new database, it seems to stay connected to the previous one, 
despite my specifying a new database to access.  Can I not access two 
databases within the same script?

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux