I would like to search multiple databases that have different passwords etc. Is there a way that I can search different databases and have the results ordered together? I suspect it can be done but I am unsure of how.

Oh wow! What a strange idea! Did you consider doing the queries for each, storing the results in a temp table? It does sound convoluted just writing this suggestion down!

The reason I ask is that each sub domain will have a site and database with the same tables in. Each will display the relevant data from their database on their sub domain. What I also want to do is display all the contents from all the databases as if it was one site. Confusing I know but ideal if I/someone can work it out.

Have you considered just using ONE table and adding a subdomain_id column to allow access to each sub domain to just their records?

Well to be honest the way my databases are set on my server I can access across domains which is what I will actually be doing. What I have thought is that when the entries are added they submit to 2 databases (their own plus my central database) but this will involve more work in changing the admin sections of my script which is pretty time consuming. :-(

I have now managed to connect to 2 databases with the same pass but I am struggling to UNION the results. I am getting close but just failing at the last step. My code is :

and the error is :


Anybody any ideas where I am going wrong?

Wow, yeah UNION! It's been a while since I last used a "union", but what are those ",$db" and ",$db2" stuff?

Those are my connections to the database 1 and database 2. In fact I should check that they work individually first

Nope that doesnt seem to work. I think the connection is ok but the actual query is incorrect.

I think I may have to change tact on this one
What is the maximum tables a database can hold?
The way I plan to set this up means approx 400-500 tables with about 10 rows in each (searched at smaller intervals) and 1 table with about 10,000 rows (searched at a very high rate). Is this feasable, impossible or just another stupid idea?

Never got the answer to that one, but supposedly nothing you or I can can throw into a single DB is too much for it to handle.

Anyway, I was asking about the commas in my last reply, why are they there?