php Programming Glossary: friend_id

http://stackoverflow.com/questions/1977904/friend-of-a-friend-in-php-mysql

something like this SELECT user_id FROM friends WHERE friend_id 1 user ID I want to know how a site like facebook and some others..

How to make an add friend/defriend function in PHP?

http://stackoverflow.com/questions/2542800/how-to-make-an-add-friend-defriend-function-in-php

table users_friends with the following fields user_id and friend_id . Well so let's say my user_id is 5. Your user_id is 10. I want.. newly created table with the following values user_id 5 friend_id 10. So let's say you want to display all of my friends you could.. such as SELECT FROM `users` WHERE `user_id` IN SELECT `friend_id` FROM `users_friends` WHERE `user_id` '5' Sure enough removing..

Need help understanding Doctrine many to many self referencing code

http://stackoverflow.com/questions/3290319/need-help-understanding-doctrine-many-to-many-self-referencing-code

# select friends of given user # user myFriends select friend_id from friends where user_id 1 # select users that are friends.. # user friendsWithMe select user_id from friends where friend_id 1 ah ha select users that are friends of given user . so this..

Database and query to store and retreive friend list

http://stackoverflow.com/questions/8208073/database-and-query-to-store-and-retreive-friend-list

my_friends is following ...id..........user_id............friend_id........approved.... ...10.........20 ..................25...................1............ steps First get all data with join query corresponding to friend_id. And second time you apply simple query for user_id and get..

array in MySQL

http://stackoverflow.com/questions/896485/array-in-mysql

id int not null auto_increment user_id int not null friend_id int not null primary key id INSERT INTO people name VALUES 'Bill'.. 'Bill' 'Charles' 'Clare' INSERT INTO friendships user_id friend_id VALUES 1 3 2 3 SELECT FROM people p INNER JOIN friendships f.. p INNER JOIN friendships f ON f.user_id p.id WHERE f.friend_id 3 id name id user_id friend_id 1 Bill 1 1 3 2 Charles..