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
sexfield accepts only:maleandfemale
加载中,请稍侯......
精彩评论