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

Retrieving a User’s Friends’ Listings

Problem

I need to retrieve all of a specified user’s friends’ listings using FQL.

Solution

SELECT title, url, description, price, category FROM
 listing WHERE poster IN (SELECT uid2 FROM friend WHERE uid1 = $user);

Discussion

Since this is based on a query on the friend table, you can make it only when user is the current loggedinuser.

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