We need a script that searches Facebook status updates *by location* (ie. "Lives in New York, New York") for specific keywords (ie "Football game") for the last 24 hours and collects the total number of search results and the members location. This data will be placed in a table in our mysql database.
You may want to look at [url removed, login to view] which provides a real-time look at facebook status updates. We would like to capture this data (for the last 24 hours) according to location which is posted near top of pages (ie "From Whiting, Iowa" or "Lives in Buffalo, New York").
All work must be done on the server side through scripts.