Using $DB object on other databases than vB?

[RoutineX]

I'm trying to write my first product in vB and had some problems with the database connectivity.

I have some data on another database that I don't want to insert into the vB database.

Shouldn't it be enough to give select access to the other database on the vB user and than do a query like:

$somevar = $db->query_first("SELECT blabla FROM unixusername_otherdb.table");

I guess I could install mysql 5 and create a view, but was wondering if there was any other ways.

Thanks =)

[Cap'n Steve]

I think the database connection can only deal with one database, although it looks like you know just as much about MySQL as me.

[Adrian Schneider]

You could create a second database object for your other database.

[version2]

Originally Posted by SirAdrian

You could create a second database object for your other database.

How would one do that with VB's database class?

[Eikinskjaldi]

Whilst you could create a second object, you were correct the first time.

Shouldn't it be enough to give select access to the other database on the vB user and than do a query like:

$somevar = $db->query_first("SELECT blabla FROM unixusername_otherdb.table");

will work. You can also join across databases.