Multiple connections question

[macca_25]

Hi all,
If i have the following query:

$query_project = mysql_query("SELECT * FROM clients,pm_projects WHERE clients.client_id=pm_projects.client_id AND pm_projects.pm_project_id='" . $_GET['project_id'] . "'");

am i able to make two connections to mySQL databases and run the above query? The clients and pm_projects tables come from different databases. Is this possible, or do i have to make two seperate connections and two seperate queries?
If not, can anyone suggest the best way?

Cheers,
macca

[Weedpacket]

Two separate connections to two separate databases need two separate queries and two separate result sets. So you'll have to do the joining yourself. (In MySQL at least, as far as I can recall about its development; I understand the PostgreSQL group is working on trans-db joins....)