Yeah, sorry, i know... i kinda changed my mind while typing it and didn't fix it, lol.
I'll try to simplify.
1 friends table for each user. Fields are: User ID (of the friends), confirmed status and possibly whether or not someone has added you as a friend.
By using User IDs, it should be easy to target a table belonging to another user and modify friend status as needed.
For every User ID on a person's friends list, just pull down the name and profile pic or whatever else belonging to that user.
Does that make more sense?
__________________
Subtlety is my middle name... and first and last in case you didn't get the point.
|