O'Reilly logo

Facebook Cookbook by Jay Goldman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Friend List Members Table

Problem

What’s the schema for the friendlist_member table?

Solution

The friendlist_member table records the friends that a user has placed into his friend lists. Its fields are listed in Table 8-10. Queries to this table will only return data the current user is allowed to see (i.e., you can’t request friendlists for users other than the current loggedinuser). More information about this table, including an up-to-date listing of fields, can be found at http://wiki.developers.facebook.com/index.php/Friendlist_member_(FQL).

Table 8-10. friendlist_member table fields

Name

Type

Index

Description

flid

int

flid (friendlist ID) of the friend list. You can only query for flids owned by the current loggedinuser.

uid

int

 

uid (user ID) of the friend that the current loggedinuser has placed in the friend list.

Note that only the field marked as “Index” in this table can be used in an FQL query’s WHERE clause, but any of the fields can appear in the SELECT.

Discussion

If you’d rather use the API to access friendlist_members, try the Friends.getLists() method.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required