Search multiple databases Running a website on Drupal 6.

I'm currently using Faceted Search to search the default database for the website.

I've installed a separate Knowledgebase application (KB Publisher) which has it's own database and search, but I would like to use one search box (the default website search box) to index/search BOTH the default website database &amp; the Knowledgebase database.

I'm not really a hard core programmer and am looking for some ideas/assistance in doing this?

Thanks,

John
I don't think any easy solution exits. But you can connect to another database by adding below lines into your settings.php file.

$db_url['mydb'] = 'mysql://user:pwd@localhost/anotherdb';

and use db_set_active() function in appropriate places to query other database while your existing database index. You may need to have a deep look in to the Search module for that.