Pages
Categories
Old Posts
- February 2010 (1)
- December 2009 (4)
- November 2009 (1)
- October 2009 (1)
Author Archives: david
Some cool Flash widgets
Just came across some cool Flash widgets on abowman.com, check them out.
Pengiuns: they follow your mouse around.
Fish: click on the pond to feed the fish
[edit]turns out it was the FollowSite plugin that was slowing up my blog – lousy plugin that does not work[/edit]
Posted in Uncategorized Leave a comment
Play a game and donate water
Try it out: Play a game online and do some good while you’re at it.
Posted in Uncategorized Leave a comment
Act on Global Warming
Get active about global warming and the failure of the Copenhagen conference, click the logo and send an email to our ‘leaders’.
/* begin styles for RSS Feed */
.rss-box-action {
margin: 0em;
width: 160px;
background-color: #E2EBD8;
/* Change above line to changer background color [...]
Calculate the Running Balance
How to calculate the running balance on a ledger using self-joins.
Find user’s most recent post in each thread
One common problem that my sequence method can help to solve is how to display the most recent entry that a user has made in each thread that the user has contributed to:
SELECT * FROM posts WHERE usedid = $userid AND postid IN
(SELECT t1.postid, COUNT(t1.postid) AS sequence, t1.postid <= t2.postid AS flg
FROM posts t1 INNER [...]
How to Sequence each Sub-set of Records
How to find/display/keep/delete the first/last n posts/records/entries for each user by using a sequence.
The Most Truth That I Know