TaylorLee

Thanks for the catch. I am working on it now. Can't wait until I'm efficient at this, lol.

Thank you! What a help. I thought it might be something like that but when you are wandering in the dark its hard to pick a definate route. Thanks again, Taylor

Good advice! . When I get my new data base "scores" how will I find the average? Isn't AVG() only good for columns not rows. Also, how will I link the average score with golfer associated with it. I have read up on mysql joins but can't seem to make sense of it yet. If joins is the answer guess it's time to start reading some more! lol

BTW, there won't ever be more that 6 scores to average. As a matter of fact, I am currently trying to find a way to erase the oldest score when a new score is entered. Any light that can be shined on this will be a big help as well.

Hi, this may be more of a php forum thing but I will try here first. For the record, I am new to php/mysql. I have a table "Players" that hold info on a group of golfers. For example a record would be like this: 1(id), John, Doe, 75, 72, 70, 78, 78, 75. The six numbers are golf scores that I would like to find an average also store it back into the database. The problem is that I can only seem to average a column. Not only that I wonder if I will have problems because I have data in my row that I do not want to be averaged, the players names. So, my question is how might I go about finding this average? Any help will be greatly appreciated. Thanks in advance. Taylor

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!

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