Displaying from 2 Table

wxdqz

New Member
Dear Friends
I have a problem to display my data from two table.
For your info.. this is my problem ..hope someone can help
This is my Table:

mysql> desc AddressBook;
+----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+----------------+
| ItemID | bigint(21) | | PRI | 0 | auto_increment |
| OwnerUD | varchar(80) | | | | |
| Nickname | varchar(20) | | | | |
| Email | varchar(64) | | | | |
| Name | varchar(64) | YES | | NULL | |
| Note | varchar(64) | YES | | NULL | |
| gid | bigint(21) | YES | | NULL | |
+----------+-------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

mysql> desc addgroup;
+-----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+----------------+
| gid | bigint(21) | | PRI | 0 | auto_increment |
| GroupName | varchar(50) | YES | | NULL | |
+-----------+-------------+------+-----+---------+----------------+


I want to display like this

GroupName | GroupMember

Friend <!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->,[email protected]
Classmate <!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->


Hope someone can help
Thank Man.........
 
Back
Top