@michaelh: My solution uses Flash, Javascript, and PHP.
The post-it note is a Flash SWF. Within the SWF, I have actionscript which expects the ‘status’ flash var to be specified. The actionscript sets the value of a dynamic text field to the value of the ‘status’ flash var.
I wrote a WordPress plugin to retrieve my latest tweet using Twitter’s API and write the necessary HTML/Javascript to embed the SWF and specify its flash vars. The value of the ‘status’ flash var is set to my latest tweet status.
Specifically, the final output of my WordPress plugin looks something like this:
<div class="tweet_pad" id="tweet_pad114739"><span>Gemma's got jury duty today.</span></div><script type="text/javascript">UFO.create({ movie:"https://www.barkhuff.com/wordpress/wp-content/plugins/tweet-pad/tweet-pad.swf",width:"310",height:"310",majorversion:"6",build:"0",wmode:"transparent",flashvars:"status=Gemma%27s+got+jury+duty+today."},"tweet_pad114739");</script></div>
The actionscript in my SWF looks something like this:
status_tf.text = _root.status;