Hello MySQL my old friend

With the data in the database (all except the teams), I set about creating a load of sql statements to pull the tables together and collate information together and spit it out. I did a few of these so I could see easily the amount of games I had reffed, who had been my head ref, the amount of times I had reffed in specific positions then broke down the amount of games I had reffed with head refs showing what I had done in those games based solely on that head ref.

All in all I pulled out 7 different sets of info for use. My plan now is to put in the teams that I have reffed and then add them into the games I have reffed as well. What started out as an easy way to see stats is quickly becoming a little micro site about my reffing stats. Main page could hold all stats then perhaps clicking on things could break it down more in other pages and it should have lovely graphs and pie charts to show the info as well.