I've done a number of projects for Starmen.Net, the premier EarthBound fansite.
EBDB: The EarthBound Database - EBDB is a database of enemies, items, magic attacks, and shops from EarthBound. Back around early 2004, I was learning to use PHP and MySQL, and I was getting into Starmen.Net, so I decided that a good project to try would be some sort of database of EarthBound information. I started work on it about March 2004, and I announced it on the Starmen.Net forums in September. At the time, I had it as part of my (now defunct) website; since Starmen.Net's 2005 site redesign, it has been hosted there.
Forum Avatar Guide - Forum avatars are an earned privilege on the Starmen.Net forum, so only a limited number of members have them. Thus, I created a page which goes though the user table of the forum, and lists any member who has an avatar and shows what the avatar is.
Forum Rank Guide - Similar to avatars, forum ranks are earned. This page goes though the user table of the forum, and lists any member who has an rank and shows what the rank is.
Forum Badge Guide - Badges are also earned. Unlike the ranks and avatars, though, multiple people can have a given badge, and a person can have multiple badges. There was no existing database table of available badges, so I was forced to simply include a list of badges for my page to search for. So, I have to manually add badges to my search list every time a new one is added, but once the badge is added, it will automatically report who has each badge in the list.