Relating to a new table in mysql

linux1880 · #1 (**permalink**) 09-22-10, 04:31

Hi friends,
I have just added a 'groups' table to mysql database. I already have a member table that has a group_id field. Should I relate member members of members table to different groups in php or mysql?
Please it would help a lot if you can give me some example code.

r937 · #2 (**permalink**) 09-22-10, 07:54

definitely you should relate the tables with sql, not php

for example

Code:

SELECT members.username
     , groups.groupname
  FROM members
LEFT OUTER
  JOIN groups
    ON groups.id = members.group_id

Internet Services

Web Development

Digital Marketing

Consumer Tech