Just like we can limit the number of results from a Graph Connection, we can also place a limit on the number of results from FQL requests, a practice recommended by Facebook in the Developer Documentation.
In this recipe we're going to request a small list of the user's friends, using the LIMIT capabilities of the FQL language to return only 10 results.
The requests in this recipe build on those explored for the earlier recipe Using subqueries in FQL. We don't require any additional Extended Permissions from Facebook, just an authenticated user.
Paging and limiting results from an FQL query uses much the same syntax as in SQL the LIMIT key word. It's easier to show than it is to explain so, to load the first 10 friends of the current user, we'd use the following FQL query:
SELECT uid,name
FROM user
WHERE uid
IN (
SELECT uid2
FROM friend
WHERE uid1 = me()
)
LIMIT 10
That would grab the friend results 1 through 10, but if we wanted to...