Query Master
Query Master

Reputation: 7097

How to get All facebook photos from FQL

I am using FQL to collect all Facebook photos for the application also i have 533 photos on facebook but the issue is that this query will return only 400 records.

FQL QUERY

SELECT src_big,target_id FROM photo WHERE pid IN
(SELECT pid FROM photo_tag WHERE subject='".$session_fbuserid."') OR
pid IN (
    SELECT pid FROM photo WHERE aid IN
        (SELECT aid FROM album WHERE owner='".$session_fbuserid."' AND type!='profile')
)

My Facebook Album

enter image description here

Upvotes: 2

Views: 1819

Answers (1)

Ben
Ben

Reputation: 2651

Add limit 1000 to the end of your query.

SELECT src_big,target_id FROM photo WHERE pid IN (SELECT pid FROM photo_tag WHERE subject='".$session_fbuserid."') OR pid IN (SELECT pid FROM photo WHERE aid IN (SELECT aid FROM album WHERE owner='".$session_fbuserid."' AND type!='profile')) LIMIT 1000

Upvotes: 1

Related Questions