The code below works except I don't need people_fname twice. Is there a way to store membership_name into an array through the query? If I do this through PHP it still shows people_fname twice.
mysql> SELECT GROUP_CONCAT(membership_name) AS membership_name, people_fname
-> FROM membership,people_membership,people
-> WHERE membership.membership_id=people_membership.membership_id
-> AND
-> people.people_id=people_membership.people_id
-> AND
-> people_membership.people_id=3;
Also I think is faster to join your tables instead of selecting all...
mysql> SELECT GROUP_CONCAT(membership_name) AS membership_name, people_fname
-> FROM membership,people_membership,people
-> WHERE membership.membership_id=people_membership.membership_id
-> AND
-> people.people_id=people_membership.people_id
-> AND
-> people_membership.people_id=3
-> GROUP BY
-> people.people_id;
+-----------------+--------------+
| membership_name | people_fname |
+-----------------+--------------+
| AICP,PP | John |
+-----------------+--------------+