Forgive me if this has been answered before, but looking at the questions asked I did not see my answer already in StackOverlow. I am an experienced PHP programmer getting to know the Facebook API. I think the FQL implementation is pretty freaking cool. My knowledge of SQL statements will make the learning experience very smooth. However, Facebook's documentation seems to negate that a few times. I see a list of objects I can query, but I feel like the list is missing certain relational objects. For example: I wish to get a list of the authenticated user's friend_list and the user's friends that pertain to each of the lists. I can successfully retrieve an authenticated user's friend list and a list of their friends, but how do I get a list of the authenticated user's friends that pertain to each of his friend_lists objects?
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效,请关闭广告屏蔽插件后再试):
问题:
回答1:
Ok, so further research has led me to find a complete list of the tables part of the FQL database. this can be found here : http://developers.facebook.com/docs/reference/fql/ on the left hand side is a list of tables and lo and behold, there a relational table for friends and friendlist called friendlist_member. So at this point I can get a list of the friendslists created by the authenticated user and then do another query to get a list of ids of the users in that friendlist. Finally I do a final query to get details like name and photos of those users.
回答2:
Use the following fql:
SELECT flid, owner, name FROM friendlist WHERE owner=me()
For more details,
http://developers.facebook.com/docs/reference/fql/friendlist/