Geek Answers Handbook

Fql join can i join two tables with FQL?

I have the following FQL, I want to join the user table to add a name field! How can i do this? After I checked the normal left connection, I got an error message (601 connection is not possible with FQL). How can I join and add a name field?

<!DOCTYPE html> <html> <body> <div id="fb-root"></div> <a href="#" onclick="getPhotos();return false;">Get Photos</a> <script src="http://connect.facebook.net/en_US/all.js"></script> <script> FB.init({ appId: 'yourAppID', status: true, cookie: true, xfbml : true }); function getPhotos() { FB.login(function(response) { if (response.session && response.perms) { var oneWeekAgo = Math.round((new Date().setDate(new Date().getDate()-7)) / 1000); FB.api( { method: 'fql.query', query: 'SELECT pid, caption, aid, owner, link, src_big, src_small, created, modified FROM photo WHERE aid IN (SELECT aid FROM album WHERE owner IN (SELECT uid2 FROM friend WHERE uid1=me())) AND created > ' + oneWeekAgo + ' ORDER BY created DESC LIMIT 20' }, function(response) { alert('Photos: ' + JSON.stringify(response)); } ); } } , {perms:'friends_photos'}); } </script> </body> </html>
+4
source share
2 answers

Do something like this:

 FB.api({ method: 'fql.multiquery', queries: { 'query1': 'SELECT uid2 FROM friend WHERE uid1 = me()', 'query2': 'SELECT vid, owner, title, description FROM video WHERE owner IN (SELECT uid2 FROM #query1)' } }, function(response) { // response should have 2 objects in it, both containing an fql_result_set // array with the data and the name you entered for the query (ie 'query1') alert('Photos: ' + JSON.stringify(response)); });
+11
source

you need to run a subquery like

 https://api.facebook.com/method/fql.query?query=SELECT uid,pic_square, first_name, last_name from user where uid IN (SELECT uid FROM page_fan WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = me())AND page_id = PAGE_ID)&access_token=YOUR_ACCESS_TOKEN

I need my friend’s name, pic from the page who liked this page. Run the subquery and it works.

Check this link https://developers.facebook.com/docs/reference/fql/

Facebook has published its database. Hope this helps you.

+4
source

More articles:


All Articles