Sports Statistics Updating

lightningrod66

I have a sports fansite which has a statistics page. I have the "per-game" data as well as "overall" data. I currently have to hand-type each set of data. I would like to use mysql and php to take the game data and have the overall data automatically updated from this.

Example:

Today's game (player, points, rebounds, assists, etc)
Season (player, points, rebounds, assists, etc).

New Season data = Old season data + today's game data

I want to just type in Today's data, and the Season data pdates from that.

How can I accomplish this? Any help appreciated.

P.S. I am a complete noob with php and mysql. I know excel and access pretty good, but my new server is LAMP.

lightningrod66

This is weird - 33 people have looked at this (as of this writing), but no one has any ideas? Do I have this posted in the wrong place?

djjjozsi

but no one has any ideas?

Ideas are available i think, but as you said you don't know much about php and mysql.

If you know acces, then the database design would be a good point in this story, and normalized database design makes this project easier.

The queries in mysql looks like the same :queasy🙁with exeptions)

In a database query count the points, and make it visible on the fly, ~if you can ~ never store counted values in a table (where you store user details).

To make a sport site with point and season management sounds easy but its really not.

lightningrod66

When I said I knew nothing about php and mysql, I meant that I haven't really used them much. I have used coldfusion and access, coldfusion and mysql, asp and access, etc. What I have done in the past is just display contents of a database "on-the-fly" after someone makes changes/updates, based on certain criteria. I can understand mostly, just haven't done much. I have never tried to use math functions in a query for example.

I tried this stats thing a while back with excel and access, but I couldn't get the data in access to format correctly (as it did in excel). I had a separate excel worksheet for each game, then had a worksheet that would add the data from each game sheet, then it was imported into access. The data, once imported into access, would not format correctly (because of the math I guess). Plus there was the many worksheets and importing and querying,... There HAS to be a MUCH easier way 🙂

Are there any tutorials/examples of this sort of thing out there anywhere? I mean there are probably millions of sports websites out there that have game and season stats. I'm sure that the people in charge of the sites don't type the numbers in there by hand each time. I have tried to look at source code from several websites, but using php you can't see the actual php code. The view source just shows up as tabular data. If anyone has ever done this please let me know where I can find examples or source code or whatever.

djjjozsi

The internet is full of good examples and much valuable things :

http://www.w3schools.com/php/default.asp
http://www.tizag.com/mysqlTutorial/
http://devzone.zend.com/tutorials

Hello, jjozsi.

lightningrod66

Thanks!

This phpexcel (listed in devzone) sounds interesting.....since I originally had this in excel format.

lightningrod66

lightningrod66;10904226 wrote:
Thanks!

This phpexcel (listed in devzone) sounds interesting.....since I originally had this in excel format.

OOPS! I wasn't thinking clearly.....my server is LAMP...excel doesn't work on Linux.