Help, connect to 2 databases and displaying their results

[jroscoe]

I have a project that I need help on (I am new to php). I need to connect to 2 different database (DB2 and MS-SQL) and display the results. Since there is a lot of data to display, I need to display like this:

                         DB2 Table Info     MS-SQL Table info

Column Name
Column Name
Column Name
Column Name
Column Name
Column Name
Column Name
Column Name
Column Name
Column Name
Column Name
Column Name
Column Name
Column Name

could someone please help asap.

Thanks!!!!

[jackiw]

I don't know how to connect do DB2, but I guess MS-SQL is similar (or equal) to MySQL and it might help you on that.

$db_conn = mysql_connect ($sql_host, $sql_user, $sql_pass) or die ('I cannot connect to the database');
mysql_select_db ($my_db);

$q = mysql_query("Select * from mytable");
while($found = mysql_fetch_array($q)) {

print $found['field1'];
print $found['field2'];
print $found['field2'];
.
.
.

}

[jroscoe]

Ok, and where would I put the code to show the DB2 info? Also, how would I do this keeping the MS-SQL info in one column and the DB2 stuff in another column? Would I have to keep doing loopd for each row?