any way to show current database

[sfullman]

I know you can change db by saying "USE db" - any way to show current database via sql query?

thanks

[liquorvicar]

maybe using

SHOW TABLES

[sfullman]

LV, your heart was in the right place but you actuall still got the answer.

That will give me an associative arra with column name 'Tables_in_my_database'.

So I can remove 'Tables_in_' and get the db.

Is there a less messy way to do it anyone?

Sam