I am tasked weekly to run some SQL again many databases and PHPAdmin is all I have to do it with.

I want to connect to DB1 run a script that counts rows from a few tables then connect DB2 and do the same. All the way up to DB56. I have been doing this manually for a few weeks now and it's not fun!

I can't figure out how to get the PHPAdmin toolset to accept multiple SQLstatements and display ALL the results at once. It's like PHPAdmin will only execute one statement and return one result?

Sorry if this is a basic question as am still learning about PHPAdmin and MySQL and appreciate any help. Thanks!

From The Dark Side Of the Moon

that is correct

seems to me that your biggest source of pain is the person who decided to put the same data into 56 different databases

It's 56 distinct customers, sorry should of indicated that.

yeah, too bad... a single database would've made your job much easier, no?