Hi, I'm fairly new to PHP and was looking for some suggestions on how to go about making a script.
Basically, I need to run 3 MySQL queries on three different servers at the same time and return results only from whatever server has the information (the querie search data will be taken from a form submission) . All three databases have the same table structure, but only one of the three servers will actually have the data being searched for.
For example, I have a form that asks for a username.. the username will exist in one of the three databases.. so I need to query all three and return results from the database the information was found in. I would also need some way of knowing which database it came from.
In PHP, is there any way I can connect to all three databases and run my selections on them all? Or would I have to do it one at a time?
Anyone have any pointers/ideas as to how I can go about this?
Basically, I need to run 3 MySQL queries on three different servers at the same time and return results only from whatever server has the information (the querie search data will be taken from a form submission) . All three databases have the same table structure, but only one of the three servers will actually have the data being searched for.
For example, I have a form that asks for a username.. the username will exist in one of the three databases.. so I need to query all three and return results from the database the information was found in. I would also need some way of knowing which database it came from.
In PHP, is there any way I can connect to all three databases and run my selections on them all? Or would I have to do it one at a time?
Anyone have any pointers/ideas as to how I can go about this?