Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


    Copyright
    Dedication
    Contributors
    Preface
    Ch. 1. Introducing Facebook Platform
    Ch. 2. Ideation and Strategy
    Ch. 3. Hello World
    Ch. 4. Architecture and Design
    Ch. 5. Setting Up Your Environment
    Ch. 6. Facebook Markup Language (FBML)
    Ch. 7. Facebook JavaScript (FBJS)
    Ch. 8. Facebook Query Language (FQL)
    Playing with FQL
    FQL Query Structure
    Functions and Operators
    Indexed Facebook Tables and Fields
    Advanced Relational Database Table Optimization
    Album Table
    Retrieving an Album
    Counting All of a User’s Photos
    Retrieving Five Albums for a User
    Cookie Table
    Retrieving All Cookies for a User
    Retrieving a Specific Cookie
    Retrieving All Cookies for a Specific Path
    Metrics Table
    Retrieving Yesterday’s Metrics
    Retrieving Metrics for a Date Range
    Alerting Yourself
    Event Table
    Event Member Table
    Retrieving an Event
    Retrieving Events Created by a User
    Retrieving a User’s Events
    Retrieving a User’s Events with a Specific RSVP
    Retrieving Events Two Users Are Attending
    Friend Table
    Friend Request Table
    Retrieving a User’s Friends
    Checking Whether Two Users are Friends
    Retrieving a User’s Pending Friend Requests
    Checking for a Friend Request Between Two Users
    Friend List Table
    Friend List Members Table
    Retrieving a User’s Friend Lists
    Retrieving a Specific Friend List
    Retrieving Friends in Friend Lists
    Retrieving Friends in a Specific Friend List
    Groups Table
    Group Member Table
    Retrieving a Specific Group
    Retrieving a User’s Groups
    Checking Whether Two Users Are in the Same Group
    Listing Table
    Retrieving a Listing
    Retrieving a User’s Listings
    Retrieving a User’s Friends’ Listings
    Retrieving a User’s Listings by Category
    Page Table
    Page Fan Table
    Retrieving a Page
    Retrieving a User’s Pages
    Photo Table
    Photo Tag Table
    Retrieving the 10 Most Recent Photos from a User
    Retrieving All Photos a User Is Tagged In
    User Table
    App Friends
    Birthday Friends
    600 Errors
    Preload FQL
    Ch. 9. Facebook API
    Ch. 10. Marketing Your App
    Colophon
    Index
    • Create BookmarkCreate Bookmark
    • Create Note or TagCreate Note or Tag
    • DownloadDownload
    • PrintPrint
    Share this Page URL
    Help

    8.47. Page Table

    8.47.1. Problem

    What’s the schema for the page table?

    8.47.2. Solution

    The page table records information about Facebook Pages. Its fields are listed in Table 8-14. Queries to this table will only return data the current user is allowed to see (i.e., you can’t request pages that the current loggedinuser can’t see). More information about this table, including an up-to-date listing of fields, can be found at http://wiki.developers.facebook.com/index.php/Page_(FQL).


      

    You are currently reading a PREVIEW of this book.

                                                                                            

    Get instant access to over
    $1 million worth of books and videos.

      

    Start a Free Trial