Displaying from 2 Table

[Anon]

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-mail],[e-mail]
Classmate [e-mail]

Hope someone can help
Thank Man.........

[andreas]

select GroupName, Name from addgroup, AddressBook WHERE addgroup.gid = AddressBook.gid;

That should work...

Andreas

[Anon]

First thank because help me..
but it only give me result like this..i already try this command :-

Select GroupName, Name from addgroup, AddressBook WHERE addgroup.gid = AddressBook.gid;

+-----------+----------------+
| GroupName | Name |
+-----------+----------------+
| Kawan | hassan hashim |
| Kawan | azlan |
| Amica | NULL |
+-----------+----------------+

The result that i want is like this :-

+-----------+-------------------+
| GroupName | Name |
+-----------+-------------------+
| Kawan | name1,name2,name3 |
| | |
| Amica | NULL |
+-----------+-------------------+

Thank man

[andreas]

Not possible...

You have to reformate the result in your PHP code...

Andreas

[[deleted]]

Not possible... in MySQL.

You'll have to print a groupname, then keep printing the Name's untill the groupname changes.
Then go to the next line, print the groupname and start pringing the names again.

[Anon]

To Andreas

thank man
but how to reformat this in php code
can u give me an simple example?

To Vincent

How to that
can u show me a simple command?

[[deleted]]

Say your query returns this:
groupname / user

firstgroup | john
firstgroup | peter
secondgroup | Murphy
thirdgroup | Carl
thirdgroup | John
thirdgroup | Frank

then your routine would look like this:

while ($row=mysql_fetch_array($result,MYSQL_ASSOC))
{
if ($sOldGroupName==$row['GroupName'])
{
echo $row['user'];
}
else
{
$sOldGroupName = $row['GroupName'];
echo $row['GroupName'];
echo $row['user'];
}
}