I have an app which I have created which contains a list of facebook page ids, and scans each one for new wall posts using FQL. This works fine, but now the client would also like to receive new comments for any existing wall post. I could go the same route with FQL, but I feel like the large amount of nested queries will bog down the s...
I have a query which is meant to track new comments on a facebook page. I've simplified the query in this case, so let's say we have this which should in theory return all comments for all posts in a page (right?): "SELECT fromid, text, time FROM comment WHERE post_id IN (SELECT post_id FROM stream WHERE source_id='{$page_id}')" Whe...
Hi i'm using this query for get next facebook events of a user: FB.Data.query("select eid,name,start_time,location,venue, pic_small,pic_big,description from event WHERE eid IN (SELECT eid FROM event_member WHERE uid={0}) AND start_time >= " + from + " ORDER BY start_time LIMIT 10", uid); But for users with many events thi...
Hi, basically I am trying to get the total of (facebook) likes for an external object via FQL. I already retrieve the comments for that object via FQL with the xid as identifier. My problem is that I need an object_id to retrieve the likes which I haven't got. Are the obect_ids only for facebook objects (pics, albums, video etc) or is t...
I have poured over the FQL APIs, done google searches - but can't figure out how to get the list of people tagged in a note. It isn't on the 'note' table. And there is no note_tags table. Anyone else worked this out? ...
I am attempting to get a list of all friend messages posted by the Facebook for Android application. The Facebook for Android application has app_id=350685531728. This returns all friend user ids: SELECT uid2 FROM friend WHERE uid1 = $facebook_user_id This returns all Facebook for Android postings for a user id: SELECT message, app...
Hi there. I am trying to do something very simple - getting a 'photo' record for a given pid. I am using: SELECT pid,aid,owner,src_small,src_small_height,src_small_width,src,src_height,src_width,src_big,src_big_width,src_big_height,link,caption,created,modified,object_id FROM photo WHERE pid = '2622555765931507709' I always get an emp...
Hello. When a user logs in to my facebook application, i want to show him a list of all of his friends that has my application installed. can I use FQL to query who's of his friends have my application installed? and if so how ? thanks! ...
Hi, I am trying to get a facebook fql query to work using the browser, I have a valid oauth token (I can make graph api calls with it). Here is the url I tried: https://api.facebook.com/method/fql.query?query=SELECT metric, value FROM insights WHERE object_id=89192912655 AND end_time=1280430050 AND period=86400 AND metric='page_fans'&a...
Is anyone able to get facebook user's address, phone # using FQL or Graph api? Have tried the following FQL and was able to get 'Current City' and 'Hometown' which are under 'Basic information' but not the 'Address' or 'Phone' which are under 'Contact Information'. SELECT name,first_name,last_name,birthday_date,current_location,hometow...
I want to retrieve all of the posts from a given facebook page along with the associated comments. I wrote this code (app details obfuscated, replace with your own in order to run it). <?php require_once('facebook.php'); $facebook = new Facebook(array( 'appId' => 'MY_APP_ID', 'secret' => 'MY_APP_SECRET', 'cookie' => true, ...
I'm using Facebook's PHP SDK, and it's been great so far. However, I have a weird issue on one page. On this page, I make a call to the graph API, then later a call using FQL. On the second call, however, I get an "Invalid OAuth 2.0 Access Token" exception. Why would the token become invalid while the first call worked? I also use FQL (s...
I wanna get a list of facebook users who like a page or interest. FQL like 'SELECT user_id FROM like WHERE object_id=113970468613229' does not work. Is there a way to do this? ...
I want to find the name, pic and page_url of the pages which installed my application. So I created this query: SELECT pic, name, page_url FROM page WHERE page_id IN (SELECT page_id FROM page WHERE has_added_app = 1) What's wrong? I understood that the "WHERE" has to be with indexable parameters - "page_id" is indexable parameter but...
Hi! I create facebook application names http://apps.facebook.com/mysapp/ and i need to implement facebook library to get uid from user. my code is require_once('inc/_facebook_library.php'); $facebook = new Facebook(array( 'appId' => 'APPID', 'secret' => 'SECRET', 'cookie' => true, )); $session = $fa...
I'm trying to get a list of all my Facebook Page Fans. All I can get from FQL is the total amount of fans for my facebook page. I can't know WHO my fans are? I have tried this: https://graph.facebook.com/somepage Anyone with an idea of how to know WHO my fans are? I.e. list the User IDs of all my fans for a specific page? I also kn...
I want to get the like_count of a page. I tried using PHP SDK, but I've given up on it because my site always stops loading after the line of code where the FQL query is executed, so I wanted to try to get the like count 'manually'. I tried using file_get_contents() on https://api.facebook.com/restserver.php?method=fql.query&query=...
SELECT uid, name, pic_square FROM user WHERE uid=1060857175 or uid=1065687593 or uid=1112477665 or uid=1198862928 or uid=1228172806 or uid=100000296599460ORDER BY name LIMIT 2 OFFSET 1 I want to ask questions when I use fql wrong but still runs (ORDER BY not space). please help me explain why run ok. facebook parse? ...
Hi, I am using the newest newest Facebook connect API for the iPhone. I am trying to get the email addresses from friends of the my app's user. I am only considering those friends of the user that are users of the corresponding Facebook app, and that have given permission to the Facebook app to use their email address. I am performing a...
Given the id of an event, is there a way to get the Facebook ids of the admins of that event through one of Facebook's many API's? The event is public. I can I know you can get the creator of the event but there may be admins other than the creator and I want to get those people as well. ...