Search query to select multiple database (Different Tables in different database)

[Sanjay Dey]

Hi !!!
I want to write search query for multiple database. I have 3 different database and each database contains nearly 60 tables. Now i want to create search function for user which will allow user to search anything from any database using PHP (Codigniter).I am using Codeigniter.

Can anyone help me to do this ??


With Thanks & Regards,
Sanjay
Software Engineer,
India

[dlite922]

You write you query as you normally would except you would prepend the name of the database to the table. i.e. db1.table1, db2.table2 etc.

If you're looking to do this using CodeIgniter API, you need to refer to the CodeIgniter manual to see how to do this.

Dan

[Sanjay Dey]

I have checked in codeIgniter manual for multiple database search at a single time with keyword. But it didnt worked out. If u have anyother process to do then please send me.

Thanks & Regards,
Sanjay