The following code uses the SimpleXML extension so it requires PHP5. What it does is search through the XML output of search results for a given user name on Twitter. The version of the code below is set up to bypass Tweets beginning with "@" indicating an @ reply message. This behavior should be simple ...

For a while I'd been trying to figure out how to output a mysql query while excluding rows with duplicate values for a specific pair of column values, and then ordering by the most recent timestamp. Some if the phrases I ended up searching the web for were get all from distinct, order by then ...