Re: [PHP-DB] Multiple instances of mysql_connect() in single PHP document.

[email protected] (Richard Quadling)
Newsgroups php.db
Message-ID <[email protected]>
2009/11/11 Chris <[email protected]>:
> Plus the assumption that they are on the same server and that the user
> you're connecting with has access to both databases..

See the initial post.

$db_material = mysql_connect("localhost", "root", "secret");
$db_labor = mysql_connect("localhost", "root", "secret");

2 connections using the same server and credentials - results in 1
real connection.

$db_material = mysql_connect("localhost", "root", "secret", true);
$db_labor = mysql_connect("localhost", "root", "secret", true);

should fix it.
-- 
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.