facebook-fql

Retrieve Facebook Fan Names

Hi everyone, I'm trying to grab the names of fans of a Facebook fan page that I administer. I've done some snooping around, and apparently, the FB API doesn't support that, but Facebook actually uses AJAX/JSON to populate the list. Anyways, can anyone suggest a way to make that call myself and grab the data as plain text? Also, I've fo...

implementing facebook search in application

I need to design a search box in my facebook desktop application, with functionality same as that of facebook search. If a name say 'sam' is entered, then all users in whose name 'sam' comes should get listed. Same as the output of this sql query: select uid, name from users where name like '%sam%'. Is there any way to implement this?...

Facebook Application Tab URL

I have a facebook application that can be added to fan pages as a tab. The application requires that users are authenticated in order to use it. This can be accomplished by using requirelogin=1 in a link which is visible only to users who have NOT added the application. This part works fine. However, after the user has given my applicat...

How can I retrieve the number of fans my Facebook page had on a given day?

How can I retrieve the number of fans my Facebook page had on a given day? I am trying to find a way to display a plot of date vs number of fans, but I can't find a way to get the number of fans by date. I have tried this: select active_users from metrics where end_time = 1263812045 and period = 2592000 in the Facebook developers too...

FQL multi query optimisation

Hi, I'm trying to get my head around whether it would be possible to do something with an FQL multi-query rather than multiple API calls. Here is my code: var queries : Object = { "user_list":"SELECT uid2 FROM friend WHERE uid1 = "+uid ,"event_id":"SELECT eid, start_time, end_time, location, pic, name FROM event WHERE eid IN (SELE...

Is it possible to fetch facebook user's profile without logging using facebook connect?

Basically, I want to fetch facebook profile avatars onto my application since I am using their login to create a particular record. How do we display their profile pic without actually forcing the user to connect into facebook to retrieve these pictures? ...

Highscores list for facebook app

Hello i have a small app on facebook called typepractice (url) and im trying to do a highscore system. I store the score in a scores object and save its id and user id in users object, like this: // setting score $scoreID = $facebook->api_client->data_createObject("scores", array("score" => 100) ); $userID = $facebook->api_client->data_...

How to make facebook FQL query response in XML format?

How to make facebook FQL query response in XML format? ...

Are Facebook Connect comments stored locally or in Facebook's DB?

If I integrate Facebook Connect on my website so Facebook users can comment on something, will the comments have to be stored in my database or will Facebook store them for me and I pull them back when I need? ...

fql query problem in php

I want to fetch the names of users on facebook. For that, I tried using FQL query. The code is, $result = $facebook->api_client->fql_query("SELECT name FROM user WHERE uid='$user_id'); But there is some problem with this. I guess the query is not getting executed or it is returning null values. I also tried using users.getInfo as foll...

How can I get older posts in public timeline FQL

I want to get the public timeline of a specific user but from a specific date. Currently, I can get the newest public timeline only and can not get the older ones. Here is my FQL: SELECT post_id, message, source_id, created_time, attachment from stream WHERE source_id IN (select uid2 from friend where uid1 == SOME_USER_ID_HERE) AND cre...

Facebook friends.getLists failing

Hi all, I'm trying a simple request on Facebook to return all my friend lists. I'm trying this in Facebook's test console, as well as through an iPhone app i'm working on. friends.getLists (also alternatively through FQL) SELECT flid, name FROM friendlist WHERE owner=4810796 I am currently logged in, so using that number should b...

how can i excute fql query with facebook Graph API

Im looking without any success away to execute fql query with the new Graph api does any body knows how can i do this? found the Answer in this excellent example : http://code.google.com/p/facebook-cpp-graph-api/ ...

Facebook - How can i make API calls on behalf of a user??

Okay.. i got the offline access session key Can some please tell me how can i update my FB status using the offline access session key i have ? Looked in the Graph API and PHP SDK but nothing helps ...

Facebook FQL Question

I'm trying to use the Facebook Javascript API to run FQL queries, and it works fine if I try and get users by username or uid, but doesn't work when I'm searching by name. function get_username() { var name = prompt("Enter name: ") FB.api( { method: 'fql.query', query: 'SELECT username FROM user W...

FQL from ASP.NET

Hey, What's the easiest way to perform an FQL query from an ASP.NET application? Do I have to download the Facebook Developer Toolkit (which I only want to use as a last resort), or is there an easier way (maybe through javascript)? I'm not doing any heavy queries if that makes a difference. (I simply want to get the user's profile pic...

Diffence between FQL query and Graph API object access

What's the difference between accessing user data with the Facebook Graph API (http://graph.facebook.com/btaylor) and using the Graph API to make a FQL query of the same user (https://api.facebook.com/method/fql.query?query=QUERY). Also, does anyone know which of them the Facebook Developer Toolkit (for ASP.NET) uses? The reason I ask ...

Convert facebook date format to javascript date

Hi i'm getting events from facebook with fql and javascript sdk. How can i convert the facebook format date in a javascript date? thanks ...

FB.Data.query with better performance

I'm using this code for take user's events from facebook: var query = 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 >= now() ORDER BY start_time LIMIT 10", uid); query.w...

what is the best way to get user name by id with FQL

hello im trying to query with facebook notification table using FQL im getting the user_id but how can i get result and get the user name in the same FQL query? ...