开发者

How to get the top 3 most liked comments on a Facebook fanpage?

How can I get the top 3 most liked comments on a Facebook fanpage? Here is what I am trying开发者_开发知识库 to do:

  • Search all comments on page x.
  • Select [1,2,3] from x where [1,2,3] are the most liked comments in descending order.
  • Output [1,2,3] to HTML.
  • Output my comment to HTML.


Since Fb is bloked at my work I could not test:

SELECT comments
FROM comment
WHERE object_id IN
(
    ###HERE A QUERY FOR A Fb_id (fanpage/link/video/message/status ...) ###
)
ORDER BY like DESC
LIMIT 0,3;
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜