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 Events with a Specific RSVP

Problem

I need to retrieve a specific user’s event based on their RSVP.

Solution

SELECT eid, rsvp_status FROM event_member WHERE rsvp_status = $status AND uid = $user;

Discussion

There are four possible statuses for event_member records: attending, declined, unsure, or not_replied. Keep in mind that this solution will return events only if the current loggedinuser is allowed to see them.

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