Facebook FQL select 2 photos of every friends?

You can use the LIMIT statement at the end of a particular query as well as ORDER BY.

You can use the LIMIT statement at the end of a particular query as well as ORDER BY. So you can get their 2 latest photos by adding ORDER BY created DESC LIMIT 2 So to get 2 from EVERY friend, you'll have to run another subquery to fetch 2 from every friend: SELECT object_id, src_small FROM photo WHERE pid IN ( SELECT pid FROM photo WHERE aid IN ( SELECT aid FROM album WHERE owner IN ( SELECT uid2 FROM friend WHERE uid1 = me()) AND type="profile") ORDER BY created DESC LIMIT 2).

If you add the "limit 2" you can only 2 rows from the query, not 2 from every friend – Hese Oct 9 at 13:19 yeah your'e right, I'll fix up my answer to account for this. I havn't tested it though, so let me know if it works – Skripi Oct 10 at 0:30.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions