[RESOLVED] Connect to two tables...

[kiwis]

mysql_connect (localhost, **, **);
mysql_select_db (mytable);

I have this to connect to my database and i have this to connect to another site on the same sever

mysql_connect (localhost, **, **);
mysql_select_db (theirtable);

This works as well because it's on the same server..

how can i connect to both so i can take data from one so what i need to do with it and insert it into mine... i could use both but i loop through data so don't want to keep connecting and dissconnecting from both all the time...

i thought maybe this would work but it does not

mysql_connect (localhost, **, **);
mysql_select_db (mytable, theirtable);

[cahva]

Just to clarify that you are using 2 different databases, not tables. Tables reside in database.
Anyway, if the mysql user can access both databases you can easily use them. Check out the first comment in manual.

[NogDog]

Note that you can specify the DB in the query itself, you do not necessarily have to do a select_db first. (The select_db essentially tells MySQL to assume that database if it's not explicitly specified in the query).

SELECT * FROM [b]database_name[/b].table_name