What i have is a golf web site and i have members that post there rounds (scores) and i would like a script that takes thers scores adds them up and puts the in a ranking list....but the thing is i want it to be able to tell if they have better score to replace it with the better one and throw out the worst one....it will be for there 4 best rounds....and i really need two scripts one for there 18hole rounds and one for there 9 hole rounds....and i have two sripts one is a PHP script for a ranking ladder and the other is a CGI script for a ranking ladder also...but i can only get the PHP one to work but not the way i really want it to....so im at a stand still....if you need any more info feel free to contact me.
thanks for your time
Par5 Golf
Eric
Then maybe we could help you out.
At the momment all it does is allows a person to sign up for the "ladder" thats what it is , and post wins and losses for there golf matches.. it shows many stats....like %,most wins,most losses, and some others.....what i want to do is make it so you can post your scores for your round and have you be ranked by the lowest score out of there 4 best matches.....but in the same have it tell who the played (whitch it allready does)...and allow them to post scores that are lower than there earlyier scores and have the script change the scores....im just wondering if this is possable....if you need more infor let me know i can prolly think of some more if needed....but i been working with it for about oh say 6 months now and boy are my eyes tired...lol
Thanks
Eric
1. i really need two scripts one for there 18hole rounds and one for there 9 hole rounds
Well I would think not. You should be able to sort/display/update/insert these two types of info using the same script with either a column in the db for 18 or 9 holes or just by using seperate queries depending on what they ask for/click on.
2. have you be ranked by the lowest score out of there 4 best matches
No problem. You probably need to tweak the sql statement to select the lowest score for each individual player and then sort them in ascending or descending order as well.
3. allow them to post scores that are lower than there earlyier scores and have the script change the scores
I would imagine for this you have some type of input page. The script that handles the actual insertion needs to get the 4 scores from the db, compare them with the new score and write the new set of scores to the db if needed. You can then give them a message saying "your new score is not better than your 4 previous scores" or "your score was added and your highest score was dropped".
4. im just wondering if this is possable
anything's possible. ;)
What db are you using? mysql?
yes that looks like what im looking for...Yes i have msql.db...and i would like to be able to clear there scores for the month seeing that this is a monthly ranking.
I have a ranking system that just does the wins and losses so im wondering if i can use that as a base....just wondering....
Wish i had your skills thats for sure..
im working on trying to install a cgi message board and its hard to do and i only have to diffrent files...and i still cant do it...lol
So any help would be greatly helpfull..
Eric
