Changes to this search and display:
<[url removed, login to view]>
1 -Results are coloured pink for females. I want to keep this, though if results are sorted by gender with 'F' selected, I want all results with a white background.
2 - Add functionality to search by age. This is a bit more tricky than searching by gender, year, etc. Age will need to be calculated by comparing DOB in the entrants table to race date in the events table in my database.
3 - Searchability improvements for age, year, lastname . Replace dropdown menus with textboxes which allow searching a range of names, years or ages. Eg: Which allow users to type in "<2007" into the years field to retrieve results from races in years 2004-2007. Eg2: Allow users to type in "C*" or "B*" into the lastname box to find runners with a lastname starting with the letter C or B. Eg 3: Allow users to type "2004, 2006, 2008" to retrieve results from these 3 years. Eg 4: Typing "45- 60" in the age text field should return results with participants aged between 45 and 60.
4 - Message when no results match. At the moment, if you type 'xxx' into the lastname textbox and then click search, you will see the headers for the table, but no results. If there are no results, I would like these headers not to appear, but instead be replaced by a message saying, "No results match your search criteria. Please try again".
5 - Profiles. The firstname and lastname of each participant have been concatenated in the 'name' field of the table. I would like this field to be hyperlinked to a profile of the athlete which would appear as a pop up window, and contain the results of that athlete for all years they have competed (in a similar manner as you would see if you searched for that athlete by their last name), as well as a message to be discussed.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
The attached files utilise php and mysql. Results should be viewable using all major browsers.