What is wrong with this query?!

jonno946

Hi guys...

What is wrong with my query, i am trying to query 2 databases at a time:


SELECT * FROM db1.regions, db2.user WHERE db2.region_leaders_forum_username = '$us' AND db2.username = '$us' AND db2.password = 'hihih'

Is that right or am i doing it totally wrong 🙁

Thanks 🙂

Erkilite

are you trying to access 2 db's or two tables?

if it is db's then you need to open seperate links to each.

if it is 2 tables then

SELECT * FROM regions as db1, user as db2 WHERE db1.region_leaders_forum_username = '$us' AND db2.username = '$us' AND db2.password = 'hihih';

you may also want to use something like this

SELECT db1.region_leaders_forum_username as region_leaders_forum_username, db2.username as username, db2.password as password FROM regions as db1, user as db2 WHERE db1.region_leaders_forum_username = '$us' AND db2.username = '$us' AND db2.password = 'hihih';

jonno946

i am trying to connect to 2 databases but they both use the same username/password.

Erkilite

you will need to have two connections to, one to each db.

not sure but i don't think you will be able to use a single query to access both.