Connecting to a custom database using db_connect

[Julchen]

Ok, so I did some experiments.

Using vB's existing connection and switching over to a custom database works ... kinda.
The problem indeed is this

my script switches to db2, forum script tries to access its own tables and ... *bam*

vB does not automatically switch back to its own configured database. Dang!


What works fine now, though, is including the database in the sql query itself. e.g.

PHP Code:

"SELECT * FROM ".$dbprefix."mytable" 


No switching necessary.

So basically a prefix did the trick. And I get to keep both DBs seperate, too.
Almost as good as eating cake