[resolved] Another PHP Question

slipondajimmy · 02-25-2007, 06:45 AM

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

PHP Code:

  $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 · 02-26-2007, 08:01 AM

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.

02-25-2007, 06:45 AM	#1 (permalink)
slipondajimmy Senior Member Join Date: Nov 2003 Location: Florida Posts: 2,010 117.50 NP$ (Donate)	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 PHP Code: `$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. __________________ Mascot Factory- Custom Plush, Promotional Plush, and Personalized Teddy Bears\|The Squidget - The tiny travel trailer you build from plans\| Last edited by slipondajimmy; 02-25-2007 at 08:02 AM.

02-26-2007, 08:01 AM	#2 (permalink)
jerometan NamePros Regular Join Date: Feb 2006 Posts: 588 1,620.95 NP$ (Donate)	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. __________________ Budget NP$ Hosting - Affordable CPanel Hosting! [ Click Here For Sales/Support ] 50NP Proxy Hosting \| URLToUs \| Fast Reliable Budget Host! [ Click Here For Sales/Support ]

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)