facebook-fql

Is it possible to create and manage a group using the the facebook api

I am new to facebook application development and I am looking fro a way to create and manage a group using the the facebook api? There is a get and get list call but I have not found a way to manage groups. ...

How do I get the comments under a status update using the facebook API?

Hi, I have a user that has authenticated with facebook connect and given my app access to publish and read from his stream. I'm trying to get the comments from a specific status update using fql (see my query below), and I keep getting an error code of 1 ("An unknown error occurred"). However, when I try to get statuses, it works perf...

Facebook -- best way to do FQL "join" with event and event_member?

In a Facebook app I need to get a user's events for a date range and his rsvp status for each event. I can get the user's events fine, but at the moment I'm looking up the rsvp status for each event one at a time, and the app is timing out for people with a large number of events. I'm getting the user's events this way: $fql = "SELEC...

FQL when logged out

Is it possible to query using Facebook Query Language when not currently logged in as a Facebook user? I'm trying to simply query when the user isn't logged in, so I can return their name, but instead of throwing up any errors, it just returns a response but the fields are blank. Any ideas why this occurs, or do I need to look at storin...

Facebook current UID with FQL

How can i get my current UID with FQL.. i want to save traffic and requests with getting the the friends of a user with fql.multiquery "query1": GET NEED MY USERID "query2":"SELECT uid, first_name, last_name FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1=MYUSERID) order by first_name" should return my friends! getting user...

Facebook send messages!

Concerning interaction with other users i want to send a facebook message: http://www.facebook.com/message.php?id=XXXXX&subject=XXXXX&msg=XXXXX Note: {{c|subject}} and {{c|msg}} parameters are optional ways to pre-fill the contents of the message (the user will still be able to edit the message before sending). How can I send t...

How to retrieve user information from facebook using fqlquery?

I have the fql query as shown below. Select uid,profile_url,pic_square from user where name="Ershad" here i am getting a response as below. xml version="1.0" encoding="UTF-8" fql_query_response xmlns="http://api.facebook.com/1.0/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" list="true" But i want all the list.All the det...

Pushing facebook status updates to application server?

I'm developing a Facebook application that displays the user's friends and their status. To do so I'm looking for a way for Facebook to push status updates to my app server. In other words, an asynchronous status update notification mechanism. At present the application continuously polls the user's stream using a FBL request, which can ...

Facebook FQL user table `sex` field : how to return male/female even the user is using different locale?

Situation: my facebook application ( http://apps.facebook.com/mymagicmirror/ ) needed to detect user's gender, and then query opposite sex or male or female FQL: SELECT uid, name, pic, sex FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1='.$user_id.') and sex='male' Problem: When the facebook user is using other locale, th...

iPhone facebook connect FQL Query to get user's friends

I'm trying to get a list of user's friends using fb connect for the iphone. I've tried both of the following FQL Queries, but they don't seem to be returning anything. which one is correct if any ? NSString* fql = [NSString stringWithFormat:@"select flid,name from friendlist where owner=%lld",[self fbSession].uid]; or NSString* f...

Merging data from two different data sets (Facebook & MySQL)

I'm wondering if this is the best way to tackle this issue. I am merging a Facebook users friends data, (from facebook - returns a multi array) with the votes from the users in that list that voted (from MySQL). This is how I accomplished this. I'm a junior developer and looking for help on making my code as optimized as possible. ...

How to get list of online friends using FQL with facebook API ?

I have got my friends list after getting logging in on facebook using Facebook connect Java script client API. I want list of my friends that are online at given time. ...

Facebook Comments Count

Hello, I am trying to write a Facebook query that will return all comments posted by a user to his friends, however I can't seem to find the correct schema. Its as if there are no 'indexable' fields to build this. Any suggestions please? With thanks, Wineshtain ...

get my facebook friends attending to events

hey i want to get from facebook the events that my friends are going to them. for example eventId1 (friend1,friend2,friend3) eventId2 (friend10,friend55); and so on... how can i accomplish it ? thank for replays. ...

Fan count for a Facebook Fan Page

I needed to pull the fan count for particular fan pages on Facebook. After digging through the API, I couldn't find a way to do this with the API "proper." Instead I fell back to a FQL query, and it worked quite well. select fan_count from page where page_id = <FAN_PAGE_ID> What did I miss about the Facebook API. Is this the only w...

How to connect an application with Facebook?

The topic may be a bit ambiguous. I am writing a Python application. I want to upload it on Facebook as a Facebook application (NOT Facebook Connect). But I am having the hardest time figuring out how to implement the features of my application with Facebook. My application currently uses a MySQL database. Now I want a user of Facebook...

Help needed - fql query in facebook api

I want to get my friends picture and their last status message with time. message,time FROM status pic_square FROM user $status = $facebook->api_client->fql_query("SELECT message,time FROM status WHERE uid in (SELECT uid2 FROM friend WHERE uid1=".$user.")"); echo "<pre>"; print_r($status); echo "</pre>"; ab...

One shot fql query - facebook api

$status = $facebook->api_client->fql_query("SELECT message,time FROM status WHERE uid in (SELECT uid2 FROM friend WHERE uid1=".$user.")"); echo "<pre>"; print_r($status); echo "</pre>"; above query returns all statuses, i want only last 2 status messages. I have to make it with fql only. can anyone show me how its done?? ...

Combine 2 fields returned in FQL for a 3rd query

I want to combine the results of status_id returned from status table http://wiki.developers.facebook.com/index.php/Status%5F%28FQL%29 and comments from stream http://wiki.developers.facebook.com/index.php/stream%5F%28FQL) to retrieve comments for a user (in a single multiqery maybe) Something along the lines of: query1:Select status_i...

How can I get a limited no of friends from facebook using fbconnect and FQL

How can I get a limited no of friends from facebook using fbconnect and FQL ...