I'm not making two connections, I'm making one and only one call to
mysql_connect. Also, there is no way in that function as per the definition
page of it (http://us3.php.net/mysql_connect) to have the database selected
as per your example below.
With my connection though, when I do:
$dbh = Mysql_connect(blah, blah, blah)
Mysql_select_db("db1")
I do call:
Mysql_query("query", $dbh);
For some reason even though I am calling mysql_select_db("db1") it is
latching onto the first available database it has access to (or not as the
case/permissions may be) and chooses "db2" instead.
I don't know why, connecting to the MySQL 3.23 it selects the right
database, connecting to the Mysql 4.x server it doesn't allow a selecting of
the table even though I do the select function and it returns true as it was
selected properly.
On 8/16/03 12:23 AM this was written:
> If you are doing this:
>
> $dbh = mysql_connect("db1", blah blah blah);
> $dbh2 = mysql_connect("db2", blah blah blah);
>
> Then
>
> $r = mysql_query("select * from mytable");
>
> will use the db2 connection, because it is the most recent. However, if
> you do this:
>
> $r = mysql_query("select * from mytable", $dbh);
>
> it will use the first connection, as specified in the handle that is passed
> back by mysql_connect. mysql_query uses the most recent connection by
> default; you can override this action by specifying which DB handle to use
> for a given query. Replace $dbh with $dbh2 to select from tables on the
> second database.
>
> Peter
>
> On Fri, 15 Aug 2003, Thomas Deliduka wrote:
>
>> Here's the stats:
>>
>> Two servers:
>>
>> Server 1, Mysql 4.0.12, PHP 4.3.2, apache 1.3.27
>> Server 2, Mysql 4.0.14, PHP 4.3.2, apache 1.3.27
--
Thomas Deliduka
IT Manager
-------------------------
Xenocast
Street Smart Media Solutions
http://www.xenocast.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
