Im trying to create a friends list in a database but dont know how to program the input structurally
If someone approves someone as a friend, i donno how to do it
whats easier?
A) FriendsId - Friend A - FriendB [this would be a hige list]
or
B) FriendID -- Friends
I donno how id put multiple entries in friends for b tho?
Creating List Within DB
Moderator: General Moderators
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: Creating List Within DB
An A-B relationship table would be better. Yes, huge lists are what databases are good at.4Boredom wrote:A) FriendsId - Friend A - FriendB [this would be a hige list]
(#10850)
- Ollie Saunders
- DevNet Master
- Posts: 3179
- Joined: Tue May 24, 2005 6:01 pm
- Location: UK
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA