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
精彩评论