Re: mysql_query - CREATE DATABASE

Shawn McKenzie wrote: > R B wrote: >> Hello, >> >> When i create a mysql database with the next command: >> >> mysql_query("CREATE DATABASE my_db",$con) >> >> In the server is created the database, but usually the name is created with >> a prefix. >> >> In this case: someuser_my_db >> >> How can i detect with PHP the complete name of the new database created? >> >> Thanks >> > > There may be a better way, but off the top of my head, translate this to > PHP: > > use information_schema; > select SCHEMA_NAME from SCHEMATA where SCHEMA_NAME like '%_my_db'; > > Now of course you could have multiples there, like user_my_db and > user2_my_db. Not sure about that, maybe it would be the last one in the > returned records? > Using mysql_list_dbs() and mysql_db_name() would acheive the same, however from the man page of mysql_db_name() there is a neat contib: $result = mysql_query("SELECT DATABASE()"); $dbname = mysql_result($result, 0); -- Thanks! -Shawn http://www.spidean.com