Importing Data

Over the weekend I imported in enough data into my database to start to build the actual World Cup website. I did this using Excel and some nifty formulas that imported in each team and their flag, and then, with some copying from Wikipedia and BBC.co.uk, I created another script to import in the details for each game.

Once this was created it was easy enough for me to throw together a simple page that shows each group's details. This page only has a dropdown list for the groups, a datagrid for the group table, and then another datagrid to display each game in the group.


Next: The playoff stages...