sstangle73 Posted September 24, 2007 Share Posted September 24, 2007 Hey everyone i am tring to make a friends list like myspaces where you can add friends i just have a few questions how would i store it in the db im thinking that i need to store 3 things the 2 people's ID and a 1 or 0 - - 0 when one person hasnt accepted the friend request and 1 when they have Quote Link to comment https://forums.phpfreaks.com/topic/70528-friends-list/ Share on other sites More sharing options...
freakstyle Posted September 24, 2007 Share Posted September 24, 2007 Hey there, your right on the money. so you have your tables: Users id name status (0,1) UserFriends user_id friend_id status (0,1) just like you said would be the way to go. it will allow you to add more features down the road to. good luck Quote Link to comment https://forums.phpfreaks.com/topic/70528-friends-list/#findComment-354312 Share on other sites More sharing options...
sstangle73 Posted September 24, 2007 Author Share Posted September 24, 2007 so when they get a seccond friend its just entered into the db twice? so now we would have MY ID 1 FRIEND 2 STAT 1 MY ID 1 FRIEND 3 STAT 1 MY ID 2 FRIEND 1 STAT 1 MY ID 3 FRIEND 1 STAT 1 would you store it like that also both ways for eatch set of friends? Quote Link to comment https://forums.phpfreaks.com/topic/70528-friends-list/#findComment-354316 Share on other sites More sharing options...
sstangle73 Posted September 26, 2007 Author Share Posted September 26, 2007 neone? Quote Link to comment https://forums.phpfreaks.com/topic/70528-friends-list/#findComment-355583 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.