I need a developer to create a MySQL database from the results of a search from this page: [url removed, login to view]
When the 'Show Events in all locations' button is selected, the page will display all the events. The event addresses and details need to be clearly entered into the database so they may be used to show the locations and details in a Google Map.
I will need to be able to pull or scrape this data once a week and updates the database..
I need an admin page where I can preview all events and make changes to the data and update.
I will need a page that has Google Map API [url removed, login to view] (or newer) that will show the events on the map based on the search criteria; Event by date (month, year), Event by State, Event by distance from zip code. Events listed for the Division and Section.
Past events can show on the map for two weeks, but have a color that denotes it as a past event and will remain in the database.
For example, if the user selects a State in the search, it will zoom into the state they are searching, place markers (with select details) on the locations and list the events below the Google Map. If a user select June, 2007 it will show the location on the US Google Map of the events that are scheduled for June 2007 and list them below the Google Map.
Here is a file of what the database columns might look like, but I will leave the design up to you. [url removed, login to view]