connect to other mysql database

Topic:	connect to other mysql database
samuelb Freshman Posts: 12 Posted: 27.Jan 2006 - 19:10	I have an interesting problem. By some special reasons Im writing a new module and wanna connect to a none PN database to get some values and then connect to the PN DB and do some stuff there. I do it something like this. $dbcon = mysql_connect("localhost",$dbuser,$dbpsw); mysql_select_db($non_pn_db) or die( "Unable to select database"); $SQL = "some SQL i use" $res = mysql_query($SQL); mysql_close($dbcon); I then do a reqular $dbconn =& pnDBGetConn(true); $pntable =& pnDBGetTables(); $SQL = "insert into $table bla bla bla.."; $dbconn->Execute($SQL); the problem is that the second SQL tries to do the insert on the $non_pn_db database!? Is there a better way to connect to a second database then the first bruteforce way I uses? // Samuel
ainigma32 Professional Posts: 958 Posted: 27.Jan 2006 - 19:17	Take a look at this thread that deals with a similar problem. Make you sure you read it all. The solution is all the way at the bottom HTH
Simon online Steering Committee Posts: 13427 Posted: 27.Jan 2006 - 20:33	By the way, there will be an API in PostNuke .8 to establish a new database connection object to avoid this type of problem. -- Regards, Simon itbegins.co.uk - Zikula Consulting Please read the Support Guide
philipp2 Freshman Posts: 33 Posted: 28.Jul 2007 - 22:48	hi hammerhead, this is exactly what im searching for now, 1.5 years later. can you give me some more information about that, pls? many thanks in advance :) philipp(2)