[Resolved] Another PHP Question

[slipondajimmy]

Another PHP Question

Ok well the person I was working with has changed there mind and now I need to change what I did.

I am still working a "friends" mod and here is what I have

$sqlstr="SELECT fuid FROM ".$db->prefix("myfriends")." WHERE uid=$myid LIMIT $inf, $tranche";

Problem I am having is we have 2 mods like this. 1 that lists all of your friends, and one that we need to list friends of a certain group. they are both getting there data from the same table (myfriends) but I need the other mod to also grab a groupid so it will only display the profiles of a certain group Here are the tables.

myfriends
ref
uid
fuid

Groups
groupid
uid

What I dont understand is why the groups are in a separate table. wouldnt it have been better if the groupid where in the user table or even the myfriends table?

Im sure this does not make any sense at all but im hoping someone will understand it.

 

[jerometan]

I would personally do this :

myfriends
ref
uid
fuid
groupid

Groups
groupid
groupname

For me, I'd prefer to have the group table store strictly group-related information.
I would have a groupid and use it to link to the user table.