2009/11/11 Chris <dmagick@xxxxxxxxx>: > 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php