Need Help/Suggestions

[jdickson]

I run a high school sports site (focus is high school wrestling). This will be the 8th year of running the site and it's always a last minute fix to get things updated on the site.

My problem:

We have a match results submit page where anyone from fans, parents, coaches can enter results. Once they submit results I have to approve them via an admin page before they go live on the site.

This year we want to be able to track wrestlers by results. We have thought about entering team's rosters into the database then having an AJAX script to auto suggest who to enter. The problem is rosters are always changing and/or we cannot obtains each team's roster (over 400 teams, 20+ on each team).

Is there any good way to go about this? The problem with users entering the results is they mis-spell names so we cannot track a specific wrestler if we try to track by data users have submitted.

Confusing?

 

[aween]

The roster changes right? Does the team names and the player /coach names change? If no, then you can submit the info yourself through your admin panel. And then use AJAX to give a auto suggestion depending on the keyword they enter.

Advice:
Try going to the dude who is making the rosters, if he has a excel/word other file format file, you can easily import it with a script in to your database.