[advanced search]
 

Go Back   NamePros.com > Discussion > Web Design & Development > Programming

Programming PHP, Perl, Ruby on Rails, AJAX, HTML, XHTML, CSS, JavaScript, MySQL and any other coding topics.


Closed Thread
 
LinkBack Thread Tools
Old 02-25-2007, 06:45 AM   #1 (permalink)
Senior Member
 
Join Date: Nov 2003
Location: Florida
Posts: 2,010
117.50 NP$ (Donate)

slipondajimmy is a splendid one to beholdslipondajimmy is a splendid one to beholdslipondajimmy is a splendid one to beholdslipondajimmy is a splendid one to beholdslipondajimmy is a splendid one to beholdslipondajimmy is a splendid one to beholdslipondajimmy is a splendid one to behold


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.

Last edited by slipondajimmy; 02-25-2007 at 08:02 AM.
slipondajimmy is offline  
Old 02-26-2007, 08:01 AM   #2 (permalink)
NamePros Regular
 
Join Date: Feb 2006
Posts: 588
1,620.95 NP$ (Donate)

jerometan is a name known to alljerometan is a name known to alljerometan is a name known to alljerometan is a name known to alljerometan is a name known to alljerometan is a name known to all


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.
jerometan is offline  
Closed Thread


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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Site Sponsors
Advertise your business at NamePros

All times are GMT -7. The time now is 12:38 AM.


Powered by: vBulletin® Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
Template-Modifications by TMS
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85