View Single Post
Old 02-26-2009, 06:50 PM   #14 (permalink)
allworknoplay
The Gregarious
 
allworknoplay's Avatar
 
Join Date: Feb 2009
Location: New York
Posts: 645
Thanks: 64
allworknoplay is on a distinguished road
Default

Quote:
Originally Posted by Tanax View Post
I'm not sure, but I would probably just do a table in db like:

friendships
fs_id
fs_user1
fs_user2
fs_type(like on vB you can have "contact" or "friend")

so when fetching someone's friendslist:
Code:
"SELECT * FROM `friendships` where `fs_user1` = '".$userid."' OR `fs_user2` = '".$userid."'";

yeah, do you know how one would show the number of possible friends on the list? what I mean by that is when your friends with someone, you are part of that network, but not necessarily friends with the 1,000's of other people in that network...

It's easy to count how many friends you have in your group, but I guess I never really figured out how to count the other possible groups....I think Friendster is the method that I am thinking about most, i don't think facebook does it the same way as friendster...


BTW: Has your $3 matrix system worked out yet?
allworknoplay is offline  
Reply With Quote