User updates

[TaylorLee]

Hi, I am new to PHP and mySQL. I am working on a golf site where it will need to have the user update info through text boxes. There are two things: 1) It will need to keep an average of the last 6 rounds. The user will need to be able to input the current round score and have it bump the oldest score of the database. 2) Also, i have a database of players that will populate a <select>. Is there a way to have the user be able to add/delete player names from this database? My question is what functions are needed to get this done. And how does one go about implementing them.

Thanks in advance!

Taylor

[spiderwell]

you basically need to build a cms to do it all, i know that sounds vague but its what the answer is.

 

this will involve a lot of rather involved code that a beginner might struggle with.

 

a good starting point would be to build a form that a user can enter a new players details with which then posts to a page that validates the input and save all of it to the database.

 

you will also need a page that lists the users, with links from each player to edit/or delete, the edit option can link to the original form for adding a user, and be adapted to be prepopulated with that users info for editting.

 

the database will need another table for scores, with a column that links to the users/players table so you can select scores filter by player, as well as some maths functions to show the last 6 rounds in averages.

 

you will also need to add security to prevent sql injection, unwanted users on the site, and preventing players altering each others scores!

 

its not a small undertaking for sure.

 

 

[TaylorLee]

Thanks for the response! It is definantly no small feat for me. But you have shined some light on the situation. Glad to have some direction. At least now I can continue to search. Thanks again!

[spiderwell]

good luck, and of course come back here if you get stuck, we are all happy to help