开发者

fql - fbconnect getting first post ever

I want to get the first stream record ever. I tried:

SELECT post_id,created_time FROM stream WHERE source_id = 610611346 ORDER BY created_time ASC LIMIT 1

But it gives me the LATEST instead of the FIRST post :(. I increased the limit to 5 just to have a look at what it was bringing back and it is simply the last 5 posts in ascending order. I guess I'm confusing LIMIT with like a开发者_JS百科n index. How can this be done?

Mike


What happens if you:

SELECT post_id,created_time FROM stream WHERE source_id = 610611346 ORDER BY created_time DESC LIMIT 1
0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜