Em Andamento

Search and Display Enhancements (2010 extension)

I'm wanting to extend the search and display options you can see here: [url removed, login to view] The pages are searching the results database of a running race over a course which is 240km long most years, but is sometimes shortened to 222km when bad weather prevents runners from ascending to the top of the mountain). Requirements: 1 - Searching. By adding 'time', 'number of starts' and 'number of finishes' to the search fields. As with other fields, I'd like these to be able to be searched with operators such as <, >, <=, >= ? and * Eg: A person might search for people who've finished the race more than 4 times by typing >4 into the numfins field, or to find people who've finished between 32 and 33 hours by typing 32* into the time field. 2 - Display. The results_sd_display table is almost finished. I'd just like the 'Starts' (number of times each competitor has started the race), and 'Finishes' (number of times each competitor has finished the race columns completed. (This has been done in the all_athletes_profiles page, so should only need minor tweaking to appear as a row in the results_sd_display table). 3 - Athlete profiles. On the results_sd_display page, firstname and lastname are concatenated and linked to the all_athletes_profiles page. The table at the bottom of this page needs to be completed. Average time needs to be in seconds. Once this is done, average time for the summit and inclement weather courses is just a matter of adding "where course='summit'" or "where course='inclement weather'". The pace is a bit more tricky. For the summit course, it's a matter of dividing the total time by 240km to find the average pace per km. The inclement weather course is shorter, at 222km. For the average pace on all courses, however, the total time taken will need to be divided by (240 x number of summit finishes) + (222 x number of inclement weather finishes). Ask if you have any questions. Dave

## Deliverables

1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).

## Platform

php, mysql

Habilidades: MySQL, PHP

Ver mais: worker search, search worker, search people, search enhancements, people search work, people search find, find operators, average time hire, ask search, top employer, summit, legal typing, average php mysql, mysql search table, minor enhancements, php search mysql row, mysql search database table, display table, display field, php search database table, mysql search page, database completed courses, search options php mysql, typing page agreement, mysql weather database php

Acerca do Empregador:
( 93 comentários ) Australia

ID do Projeto: #3002084

Premiar a:


See private message.

$85 USD em 14 dias
(48 Avaliações)

4 freelancers estão ofertando em média $78 para este trabalho


See private message.

$63.75 USD in 14 dias
(239 Comentários)

See private message.

$76.5 USD in 14 dias
(39 Comentários)

See private message.

$85 USD in 14 dias
(15 Comentários)