how to retrieve data from two tables

[michael123]

I need to manipulate two tables(in different DB) to print out data, what's the effective way to do that in php code?
$conn = mssql_connect($intraserver, $intrauser, $intrapass);
$db=mssql_select_db($intradb, $conn);

$result0=mssql_query("select a from tb1");// in $db
for ($i = 0; $i < @mssql_num_rows( $result0 ); ++$i)
{
$line = @mssql_fetch_row($result0);
$productname=$line[0];

$conn1 = mssql_connect($intraserver1, $intrauser1, $intrapass1);
$db1=mssql_select_db($intradb1, $conn1);

$result=mssql_query("procedure_in_db1 $productname"); //in $db1
$arr = mssql_fetch_row($result);
print "$arr[0]";
mssql_close ($conn1);
}
mssql_close ($conn);

[Thyrosis]

You'd be looking at using the mssql_query's second variable: the connection.

$result=mssql_query("procedure_in_db1 $productname", $db1); //in $db1