[Resolved] Selecting from two databases

[jek]

Is there any easy way to select and count distinct entries from two different databases..?

Something like this:

$result = mysql_query("SELECT DISTINCT `entry` FROM `database1.table1`, `database2.table1`");
$total = mysql_num_rows($result);

Thanks in advance
//jek

[mrhappiness]

yes, it works the way you posted it (i personally don't like the ` but aside from this my queries look the very same)

of course the mysql-user you used for mysql_connect needs SELECT privileges for the databases/tables

[jek]

Oh... I didn't expect it to be that simple, so I never tried it 🙂

Thanks a lot mate!

//jek