I am a big NFL fan, and a friend and I decided to write our own NFL fantasy football application. Although we haven't gotten around to finishing the entire program, I did write a program to build and query a database of NFL player information.
The program works by creating dynamic queries based on url parameters. It actually does not provide a link to all of its functionality. If you play around with the URL, you can limit your search and order your search by any element in the database. This program was built using a MySQL database and it runs on an Apache / Linux system. To use this program, just click on any of the team logos above or click on any of the predefined queries below.
I also have posted a dump of the MySQL database, which you can find at this next url. The data was obtained by screen-scraping the nfl.com and nflplayers.com databases, but it is a couple of years out of date. MySQL database dump
The index is open to be browsed, if you would like to see all the files involved with the program. See http://aldermania.com/nfl
As you can see from my hand drawn graphics, I'm not much of a graphic designer, but I am pretty good at mimicking and modifying any web design aspects I see.
Please feel free to email me if you have any questions or comments. If you're curious, you can also download the code of these scripts in the file nfl_player_code.zip.
Charles Alderman
aldermania_football@aldermania.com