Re: help with simple db design

[H Yowza]

Ok here's what i've done:

I have a hobbies, member and memberhobby table

the Hobbies table has the following

Hobbie, char 255, 0
Hobbie_ID, int 11, PRIMARY KEY

MemberHobby:

Hobbie_ID, int 11, PRIMARY KEY ----> REF Hobbies Hobbie_ID
Member_ID, int 11, PRIMARY KEY ----> REF Member Member_ID

(both are primary keys in this instance, because many members can have many same hobbies so both have to be unique:

i.e. Sarah | Tennis
John | Tennis

Member:

Member_ID, int 11, PRIMARY KEY
Member_Name, char 255


Does that look OK?

Just having problem retreiving stuff:




mysql> SELECT GROUP_CONCAT(Hobbie_ID ORDER BY Hobbie_ID DESC SEPARATOR ', ') from Member, MemberHobby WHERE Member_ID = '23' Group by MEMBER_ID;

lists ervery hobbie for some reason :

+----------------------------------------------------------------+
| GROUP_CONCAT(Hobbie_ID ORDER BY Hobbie_ID DESC SEPARATOR ', ') |
+----------------------------------------------------------------+
| Tennis, Hockey |
+----------------------------------------------------------------+

When the memberhobbie contains:


+-----------+-----------+
| Hobbie_ID | Member_ID |
+-----------+-----------+
| Hockey | 23 |
| Tennis | 25 |
+-----------+-----------+



Edited 3 time(s). Last edit at 04/02/2006 08:46PM by H Yowza.