how would i do a join [or combine?] on 2 sepperate tables from 2 dirrent data sources [conections].. would i combine the 2 recorsets below on rsMember.ID_MEMBER = rsForumUser.ID_MEMBER you know?? mysql_select_db($database_conTL, $conTL); $query_rsMember = "SELECT memberId, ID_MEMBER, memberName, memberEmail, memberDescription, memberContact, memberLevelId FROM member WHERE memberLevelId = 1 ORDER BY memberName ASC"; mysql_select_db($database_conForums, $conForums); $query_rsForumUser = "SELECT ID_MEMBER, memberName, emailAddress, personalText, signature, avatar FROM teamtime_members ORDER BY teamtime_members.memberName"; Thanks Guys! -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
