2 database on different connections

[Anon]

I estabilished 2 connections to 2 different
hosts then i selected the database:
mysql_select_db ( $DATABASE1, $conn1 );
mysql_select_db ( $DATABASE2, $conn2 );

the query is to find duplicate nicknames:
$q = "select a.nick, a.password, a.email from $DATABASE1.members as a, $DATABASE2.members as b where a.nick=b.nick ";

I run this
$rs1 = mysql_query( $q1 );

but i get the error:
select command denied to user: '[e-mail]' for table 'members'

Anybody know if this is possible???

Thanks in advance,
Antonio
www.badpenguin.org

[webestilo]

In MS SQL Server you can use of vinculated server, but in MySQL i think tha its not posible.

[[deleted]]

What you are trying to do has nothing to do with the error.

First, you don't need two connections. (you can only run a query on one connection at a time, and one query can contain references to different databases : SELECT * FROM database.table.field

The error you get means that the user you are logging into the database as has no rights to select data from table 'members'

Check the access-rights, read the mysql manual about the GRANT statement.