Jump to content
xisto Community
Reddish

I Need Help Choosing A Database Info will be added daily. User should be able to pick selections.

Recommended Posts

Im in process of a new website. I believe the best way for it to be setup is so minimal entry is needed for it to continue running.Its a sport website which will hopefully automaticly desplay, main results and user selected results.A great example of what Im describing is xscores. The info displayed is much the same except graphics will be more appealing.Ill start with an example:Lets say we deal with a Football League.One of the pages will have the league table.I want to have detailed stats added however. ie, yellow cards, shots on target, goals.So, lets deal with player1(p1) and player2(p2) for an idea:p1 got 1 yellow card, had 5 shots on target and 0 goals.p2 got 0 yellow cards, had 2 shots on target and 2 goals.This is continued for each player of the team. So if I clicked the actual team, the database would automaticly add them up. ie, total of 1 yellow card, 7 shots and 2 goals.The whole website will be done on stats like this.Also, I would like to have an entry page that follows something like:Team Number: 0034Game Number: 4Opponent Team: 0021Players: 0021;0043;0076;0036;0024;0073;0043;etc...Yellows: 0021;0024;0073Shots: 0021;0024;0024;0076;0024;0024;etc...Goals: 0024;0024etc,etc,etc...I addition, if a user were to click on a players info page it would bring up his name, age, etc... Using the stats from the databaseAnyone know where or how I can learn my queries.Or if a certain database software is needed, what types do I need to stick by?All recomendations would be great here folks. I would however like the easier software to learn, but can spend time if needed to study it.Thanks for your time in advance, :D

Share this post


Link to post
Share on other sites

I had a look at using this script once upon a time. https://www.google.ca/url?sa=t&source=w0CbRepJURwxswkw

It deals with Soccer, but I was looking for something that worked for Hockey.
As I recall, player stats were a part of the system. Might need to rip it apart and have a look at the coding.

Share this post


Link to post
Share on other sites

Any database can be used to store the information you want. The most important thing is to organize the data so that it is easy to see the relationships between the various items (teams, players, leagues, game statistics, and so on). A relational database is ideal for this situation.

To learn more about how to design databases, check out something like http://geekgirls.com/category/office/databases/ . It is very helpful and goes through the basics step by step.

Regards,

z.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.