working with 2 database help please

[miz]

ok i have 2 dbs on same host
1 is vbulletin and the 2nd is just some info
i need about things

now mysql user have axx to both databases

so i thought ok vbulletin will use $DB_site and for the other info ill user
$predb

so when im doing $Db_site->query($query)
its will run on vbulletin db
and when im doing $predb->query($query) its will run on the other database

sounds simple right ?

so i edited config.php and added $predbname = '';
so i can use it for $predb

also i open init.php to add new db_class
and added this code :

PHP Code:

 $predb = new DB_Sql_vb;
    $predb->appname = 'Pre';
    $predb->appshortname = 'pre (' . VB_AREA . ')';
    $predb->database = $predbname;

    $predb->connect($servername, $dbusername, $dbpassword, $usepconnect); 


now my problem is like that
every time server tries to connect to host he connect to db in $predb
so he wont find vbulletin info

now my qustion is if there any way that i can use this method
with out doing mysql_select_db every time i want to use $predb instead of $DB_site ???

help appricated. thanx
MiZ

[Dean C]

To work with a seperate DB all you need to do is prefix the tablename in your queries with the database name.

e.g.

[sql]
SELECT field
FROM dbname." . TABLE_PREFIX . "table as table
[/sql]

[miz]

nahh i sloved it with better idea

PHP Code:

define('VBDB', 'vbulletindb');
define('PREDB', 'myotherdb');

function switchdb()
{
    global $DB_site;
    
        
    switch ($DB_site->database)
    {
    case PREDB:    
    $DB_site->database = VBDB;
    $DB_site->select_db(VBDB);
    
    break;
    case VBDB:
    $DB_site->database = PREDB;
    $DB_site->select_db(PREDB);
    
    break;

        
        
    }
    
} 


then if i make a function
all i do is
switchdb();
on start and end of function...

Originally Posted by Dean C

To work with a seperate DB all you need to do is prefix the tablename in your queries with the database name.

e.g.

[sql]
SELECT field
FROM dbname." . TABLE_PREFIX . "table as table
[/sql]

but you gave me an idea

i can add new define
like

PHP Code:

define(MiZDB,$dbname); 


and just to do


[sql]
SELECT field
FROM " . MIZDB. "table as table
[/sql]

as my other table dosent user prefix

btw is my first way takes more qureys ?

[Dean C]

Why make a function when you can just put $DB_site->select_db('dbname'); in your code before you run the query, and then switch it back afterwards, seems kinda redundant

[miz]

Originally Posted by Dean C

Why make a function when you can just put$DB_site->select_db('dbname'); in your code before you run thequery, and then switch it back afterwards, seems kinda redundant

cuse ill need to to do a lot of switch db
but i made it on the easyest way that can be
in init.php i added :

PHP Code:

define('PREDB','mydb.mytable');
// i need only 1 table form this db 
// so why not make life eayer ? 


after

PHP Code:

    define('TABLE_PREFIX', $tableprefix); 


and on my script its looks like that :

PHP Code:


$DB_site->query("SELECT * FROM ". PREDB ." ORDER BY id DESC LIMIT 5 "); 


simeple as that.
so when i want to use my other db i use PRED in query