> 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"; You can't do joins across connections with straight SQL. You'd probably have to load everything into arrays and do the processing in PHP. Are these tables in the same database program? Why do you have two connections? ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
