I am creating a website for a sports gaming league, in Madden NFL Football. The content is essentially just like an espn.com or any site that has sports stats. Basically I am trying to come up with the best way to manage all of the stats. After each user plays their games, they will go to the website an put in the stats from the game. The overall game stats and each individual player stats. My question is since I have minimal experience with mysql( truthfully I would know where to begin), but I do have experience with excel, is it realistic to think I could use multiple excel files to keep these stats on the website? The site will have standings, league leaders,etc but most importantly, all of these stats get their data from the stats the user inputs after their game. If anyone can give me some recommendations on what is the best way to do this I would greatly appreciate it. I just dont want to get knee deep into the process of building this stats database and find a better way to do it. Thank you in advance!!!
Try Navicat - http://www.navicat.com/ You can import from an excel file, and there is a good excel-like interface if you want to edit tables manually. Ideally the best way is to learn how to script the table updates, but this may be a good alternative until you are proficient at that. You can also save update and other command line scripts with this, and manage anything else in the database.