I need to retrieve a specific user’s event based on their RSVP.
SELECT eid, rsvp_status FROM event_member WHERE rsvp_status = $status AND uid = $user;
There are four possible statuses for
not_replied. Keep in mind that this solution
will return events only if the current
loggedinuser is allowed to see them.