Results 1 to 1 of 1
Jun 13, 2012, 08:38 #1
- Join Date
- Dec 2006
- 0 Post(s)
- 0 Thread(s)
Pull friend comment using fql -facebook-
I want to pull just one latest comment of a friend posted on my feeds using fql. As comment table have fromid which is not indexed and making relation with stream table via post_id make the query a bit tidy. I have already have frndid stored in a var.
select fromid, text, time from comments where post_id in (select post_id from stream where source_id in (select uid1, uid2 from friend where uid1=me() and uid2=$frndid)) order by time desc limit 1
Apologizes if this thread is in the wrong forum.
Any help will be appreciated.