QoQ how? 2 seperate datasources/conections
| From: | Paul Ihrig | Date: | Fri, 16 May 2003 13:58:19 +0000 |
| Subject: | QoQ how? 2 seperate datasources/conections | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27822@lists.php.net to get a copy of this message | ||
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