Dizkus

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

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

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

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)