Re: Getting database name from link identifier

On Tue, Feb 25, 2014 at 4:28 PM, Larry Martell <larry.martell@gmail.com>wrote: > Is there any way to find out what database I am connected to from a > link identifier? > > I have some code this does this: > > @ $db = mysql_pconnect($dbserver, $dbuser, $dbpass); > @ mysql_select_db($dbname, $db); > > I know at the time this is executed $dbname is what I want it to be. > But later on when I pull data using $db, I get data from a different > database. If I try to echo $db at the time of the query I get > "Resource id #5". Can I get the database name from $db? > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > You won't be able to, you will need to execute a query on that DB connection handler to check the DB name currently used: SELECT DATABASE() as DB_NAME Aziz