working with 2 database help please

[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 ?