Nicholas Bowers NicholasRBowers
NicholasRBowers
/ states and counties
Created
January 16, 2013 18:02
— forked from aghouseh/states and counties
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $counties = array( | |
| "Alabama" => array( | |
| "Autauga County", | |
| "Baldwin County", | |
| "Barbour County", | |
| "Bibb County", | |
| "Blount County", | |
| "Bullock County", | |
| "Butler County", | |
| "Calhoun County", |
NicholasRBowers
/ fb-extract-comments.php
Created
November 20, 2012 20:46
— forked from stephanschubert/fb-extract-comments.php
Extract comments from your page on Facebook
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| // Displays comments for a certain URL. | |
| $url = 'http://developers.facebook.com/docs/reference/fql/comment/'; | |
| // FQL multi-query to fetch all the data we need to display comments. | |
| $queries = array( | |
| 'q1' => 'SELECT post_fbid, fromid, object_id, text, time FROM comment WHERE object_id IN (SELECT comments_fbid FROM link_stat WHERE url ="'.$url.'")', | |
| 'q2' => 'SELECT post_fbid, fromid, object_id, text, time FROM comment WHERE object_id IN (SELECT post_fbid FROM #q1)', | |
| 'q3' => 'SELECT name, id, url, pic_square FROM profile WHERE id IN (SELECT fromid FROM #q1) or id in (SELECT fromid FROM #q2)', |