connecting to multiple databases at once and getting info

[myraleen]

i

I am back.

I am doing a program that connects to various databases and retrieves information from a table that is located in each of those databases.

I was told to either set up an array with the directory of each system, or set up an array of each of the database names and go from there.

But I'm lost.

The program is to kick users who are on the system off for maintenance, and only the admin can do it.

Can anyone point me in the right direction?

The page that calls the tables from each database is set up so that the tables are called from a table wrapper file where the database should be called in the arrays.... but another person told me the array should be listed in the initial config file itself and connected to the databases all at once there. So i'm not sure which would be the best way and just contemplating that has got me totally lost.

Confusing huh?

[tekky]

cant this be done easily by connecting as the master user and querying the mysql/users tables? (doesnt it show online/offline status?)

either way... to connect mupltie DB's you would need to make an array of the DB names, and after connecting to the server

mysql_select_db() to the approriate db, do your stuff, then loop back to the select_db() line and select the next one...

or skip the mysql_select_db() all together and use mysql_db_query(); 🙂