SQL Help

[sportsannouncing]

I'm totally lost in all of this and I've been reading too much to really confuse myself.

I want to create a web-based program that will allow me to import stats as they happen for a hockey league. From that, this is what else I want it to do...

I want the score to be seen while the game is in progress on the web site
I want the results of the previous day seen after the game is over, up to 24 hours
I want to show upcoming schedules with team logos on team pages and on the main league page
I want to be able to show league leaders and team leaders on several pages
I want to be able to show updated league standings as results are final
I want to be able to view stats for individual teams (with rosters)
I want to be able to show and print scoresheets, stat sheets, standings, etc.

When I originally embarked, someone told me that I could use a database to do all of this and to use SQL. I'm completely lost. I have a database on my computer but it's works, I have Excel, but I have no idea how to implement code for an input screen or how to write code to have "top-5's" displayed.

I thought I was catching on, but I'm not and am really frustrated, any help would be awesome. If someone can help me step-by-step, tell me what I need, point me to a place where they can get me through step-by-step (stats specifically, because I have questions, most tutorials look like you enter in one thing and that's it. I'm needing "quantity" for goals assists, penalties, etc., kind of like an inventory program).

I want to write this myself because I'm not happy with what is out there currently.

Please help...dj@sportsannouncing.com

[djr33]

You must learn to count before you can do algebra. In this case, you need to know how databases work, in a general sense, before you embark on such a complex project.
What you want really isn't that hard-- it's just very complex.
Finding the top 5s is in fact easy. Just add to your SQL statement a limit of 5, and order by [stat] descending.
But, before you can do that, you'll need to setup your whole system.

So, start by taking a look at this tutorial (and, yes, start with the basics-- the rest will fall into place after that):
http://php-mysql-tutorial.com

And, no, not really, no one has the time to walk you through every single step of such a big project. But we can definitely help you get started. Take it slow and you'll figure it out. Soon, you'll be able to take what you've learned and complete your project.