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 Events Two Users Are Attending

Problem

I need to find all of the events that two users are attending, using FQL.

Solution

Assuming the current loggedinuser is friends with both of these users (or otherwise allowed to see their events):

SELECT name FROM event WHERE eid IN (SELECT eid FROM
 event_member WHERE uid = $user1 AND eid IN (SELECT eid FROM event_member
 WHERE uid= $user2))

You’ll need to plug the two IDs in as user1 and user2.

Discussion

This should be pretty easy to extend for more than two users if you need to, and it shouldn’t affect performance considerably, since the heavy lifting is done by the database.

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