Newbie looking to collect Movie Like data

57 Views Asked by At

I'm looking to collect Facebook Movie Like information.

I don't need anything other the the Movie Likes, grouped by an ID.

e.g.:

ID, like 1,       like 2,       like 3 etc...
1,  Bad boys,     bad boys 2,   Santa Clause the movie
2,  Bad santa,    god father, 
3,  team america, inception,    the matrix
4,  bad boys,     team america, inception

I'm familiar with PHP/MySQL, so would prefer to use that. However, I really want the data so will try/learn anything.

From using the search, I found this from 3 years ago:

SELECT name, page_id
FROM page
WHERE page_id IN
(
    SELECT page_id
    FROM page_fan
    WHERE uid IN
    (
        SELECT uid2
        FROM friend
        WHERE uid1 = me()
    )
    AND profile_section='movies'
 )
1

There are 1 best solutions below

0
Tobi On

You can only get the Movie likes info of individual by requesting the permission user_likes for the individual app user.

I don't really understand your structure (...grouped by an ID). How should this work anyway?