Re: Getting database name from link identifier
| From: | Jim Lucas | Date: | Tue, 25 Feb 2014 21:41:11 +0000 |
| Subject: | Re: Getting database name from link identifier | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-322982@lists.php.net to get a copy of this message | ||
On 02/25/2014 01:28 PM, Larry Martell 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?Execute the query "SHOW DATABASE();" You should get one row back that contains the name of the database you are currently "using". -- Jim Lucas http://www.cmsws.com/ http://www.cmsws.com/examples/