I'm interested in rendering only a list of friends of a certain sex. I'm using the query below, but not having any luck:
"SELECT name FROM user WHERE sex= $sex AND uid IN ( SELECT uid2 FROM friend WHERE uid1= $fb_uid )"
From what I understand, it should work because AT LEAST ON开发者_StackOverflowE of the constraints is indexable. Am I missing something?
Here are my thoughts:
- Make sure that the user have the right permission, I guess it's
read_stream
- Make sure the user you are matching is the logged in user (maybe using
me()
instead) - the
sex
field accepts only:male
andfemale
精彩评论