StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I would suggest using FQL instead - building your FQL queries will help you understand much more what goes on in FB under the hood as well plus if you are good in SQL you can combine multiple queries to give you friends pics and their IDs from diff tables in one resultset...</p> <p>Use the FB fqlquery function call and pass your required column names there - e.g. you can see your stream from the following table: <a href="http://wiki.developers.facebook.com/index.php/Stream_%28FQL%29" rel="nofollow noreferrer">http://wiki.developers.facebook.com/index.php/Stream_%28FQL%29</a> and you can issue queries according to the examples given here: <a href="http://wiki.developers.facebook.com/index.php/Fql.query" rel="nofollow noreferrer">http://wiki.developers.facebook.com/index.php/Fql.query</a></p> <p>e.g. this gives me the newsfeed from stream table, for all my friends (only):</p> <pre><code>$logged_in_user = $facebook->get_loggedin_user(); select source_id, post_id, message, likes, created_time, updated_time from stream where source_id in (select uid from user where uid in (select uid2 from friend where uid1=' . $logged_in_user . ')) and filter_key=\'nf\' order by updated_time" </code></pre> <p>You can query the User FQL table for the picture URLs of your friends and display those URLs in image containers of the frontend lang of your choice: <a href="http://wiki.developers.facebook.com/index.php/User_(FQL)" rel="nofollow noreferrer">http://wiki.developers.facebook.com/index.php/User_(FQL)</a></p> <p>Use the Console for testing your queries: <a href="http://developers.facebook.com/tools.php" rel="nofollow noreferrer">http://developers.facebook.com/tools.php</a></p> <p>And use the MultiQuery <a href="http://wiki.developers.facebook.com/index.php/Fql.multiquery" rel="nofollow noreferrer">http://wiki.developers.facebook.com/index.php/Fql.multiquery</a> later when you are more comfortable using FQL queries</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload