A single HTML page, with 3 drop-down menus, Tags for filtering data, and an area to display results in rows. - A simple database may be required.

A single HTML page, that contains three drop-down menus, an area containing tags for filtering purposes, and an area displaying rows (which are generated/ordered depending on the drop-down menu selections). These rows will contain text that summarizes the selections chosen in the drop-down menus and tags, along with a calculated numerical value (detailed below).

The first drop-down menu will contain a list of Countries. "All countries" will also be an option.

The second drop-down menu will contain a list of Cities. "All cities" will be an option if no Country has been selected in the first drop-down menu. Once a Country is selected, the second drop-down menu will display only the Cities contained in that Country.

The third drop-down menu will contain a list of Sports.

There are 9 different tags, these will be words relating to sport equipment ("ball", "net", "whistle" etc.).

Each Country and City will have one or more tags associated with it, each Sport in the third drop-down menu will also have one or more tags associated with it. In this sense, the tags will act as a way to link and filter each Country and City to Sports.

The calculated value for each combination of selections will be calculated like this:

Each City will have two values associated with it: "Value 1" and "Value 2".

Each Sport will have two values associated with it: "Value 3" and "Value 4".

The calculated formula is: (Value 1 X Value 3) + (Value 2 X Value 4) = Score.

I want the "Score" for every possible combination of City and Sport to be generated (perhaps this should be done one time and then the results stored in a database). I need all the results to be ordered by largest score first, and then displayed in rows on the page. Each row should contain text that details the City, Sport and Tags chosen, along with the associated Score.

For example, if the user Selects "Italy" in the first drop-down menu, and "Rome" in the second, then they should see a list of all Sports whose tags match Rome's tags. The output in the area containing the rows should look something like this:

1. Rome uses a Ball and Net to play Volleyball, with a Score of 64,400.

2. Rome uses a Ball and Racket and Net to play Table Tennis, with a Score of 51,700.


Any tags that belong to "Rome" should automatically become highlighted in the filter-box area, and the non-applicable tags should be greyed out. The user should then be able to deselect tags if they wish. For example, if they deselect the tags "Ball" and "Net, then the first row in the above example should disappear from the list, but the second row should remain visible because the tag "Racket" is still selected/active.

The user should be able to select multiple Cities, and multiple Sports if they wish, and the rows should automatically reload and be ordered by largest score first.

This project will probably require a database of some sort to link the Country/City selections to the Sport selections through the use of the tags. A database may also be beneficial to store all the possible scores in order to rank the results rows, and then all database queries could be limited to return a max of 200 rows to improve performance.

I've attached a wireframe image of the layout. And I've attached a list of Countries, Cities and Sports for you to use. Along with the values (Value 1, Value 2, Value 3, Value 4) for each to calculate the Score used to order each row.

Skills: Javascript, HTML, CSS, Database Development, PHP

See more: display duplicate data database, retrieve data database java jsp display table update, data database display webpage ajax, html table filter sort, bootstrap select dropdown with search box, bootstrap filter dropdown, using php dropdown to filter mysql table data, dropdown filter jquery, html table with drop down filter, searchable drop down list html, bootstrap filter list, display data database table ajax php, display data database using flex, logo website display data database, joomla display page data database, simple php data database script, ajax fetch data database display field, display data database pdf file php, joomla display data database, simple soap post data database

About the Employer:
( 6 reviews ) Dublin, Ireland

Project ID: #20408527

Awarded to:


Hi, Hope you doing well. I read your project description and very confident to handle this project perfectly. so, give me just 2 minutes chat Let's have a discussion, negotiate costing, timeline and then we proceed Tha More

€17 EUR in 2 days
(47 Reviews)

30 freelancers are bidding on average €34 for this job


Dear Client, Hope you doing well, I am a web developer with an experience of over 6 years. I can design your website according to your choice. You can check my portfolio and reviews for reference at: [login to view URL] More

€100 EUR in 4 days
(165 Reviews)

I have developed a number of complicated projects related with all of my above mentioned expertise and won the trust of all of my [login to view URL],I have worked on a number of built-in WordPress plugins & API’s and can man More

€55 EUR in 1 day
(130 Reviews)

Hi, thank you for reading my proposal, I can design this HTML single page website with 3 drop-down menus for you and i understand the requirements in this project description. This website will be responsive on all de More

€100 EUR in 2 days
(77 Reviews)

Hi , I can do it.I will do it as you [login to view URL] give me a chance and come in chat so we can discuss about project. You will get impressed by my work. I can start work now. Thanks & Regards Krishan

€30 EUR in 3 days
(192 Reviews)

We have experience of Website in PHP, Laravel, CodeIgnitor, Wordpress, Opencart, Woocommerce . We also have experience of making Android,Window and iphone application with ionic & phonegap. Benefits in working with u More

€20 EUR in 1 day
(137 Reviews)

Hello Sir, I have read your job description regarding A single HTML page, with 3 drop-down menus, Tags for filtering data, and an area to display results in rows. - A simple database may be required. I have 6+ year o More

€19 EUR in 3 days
(129 Reviews)

Hello, how are you? I am a creditist and php expert. I am very happy to have an opportunity of bidding your project. I have carefully read your posting and understood clearly what you want. My rich php development expe More

€50 EUR in 2 days
(39 Reviews)

Hi, I’d be glad to assist for web development. I am excited for this opportunity and I have strong feeling that I could be the best fit for this job. I have 5+ years experience with web development. Proven experience i More

€30 EUR in 1 day
(72 Reviews)

Hello! I am a web developer. I have checked your project description. I can do it If you hire me, I am gonna do my best. I guarantee the good result. I will wait for your reply. Thank you.

€19 EUR in 7 days
(28 Reviews)

Dear sir! I am a senior full stack developer who has rich experiences in ecommerce website development. I have been working for 10+ years in information technology. I can fulfill your all requirements to the fullest. G More

€19 EUR in 7 days
(23 Reviews)

Dear Project Manager, Thanks for feature Job. We have gone through your requirements and we are highly interested in this project!. We can give very best solution so you can earn business from site Here is my late More

€19 EUR in 7 days
(36 Reviews)

hello mate I am very glad to place a bid to your project i have read your description carefully and i am so interested in your project. i am skillful php laravel web developer and i have finished a lot of project of th More

€50 EUR in 1 day
(44 Reviews)

Hi, I have read your project description and willing to do this for you in your required time spam with 100% Satisfaction. Kindly message me so we can discuss in detail over chat......

€30 EUR in 1 day
(56 Reviews)

Dear Hiring Manager, I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I'm a full stack developer having 8+ years of experience in designing and develop More

€100 EUR in 5 days
(16 Reviews)

here it is my pleasure to state that my Web development skills are very sharp and up to date with the knowledge of latest theme of WEB development. My Portfolio: [login to view URL] More

€19 EUR in 3 days
(17 Reviews)

I am having expertise in Html, CSS, HTML5, CSS3, Bootstrap framework,Jquery, graphic design. I have done more than 60 Jobs of Psd to Html. It will be compatible to All browsers and Devices. I can create your HTML-Co More

€30 EUR in 7 days
(25 Reviews)

hello Sir I have 5year exprince in web development please give me chance to done this job thanks amin

€34 EUR in 3 days
(21 Reviews)

Hi *~*. Nice to meet you.. I read your description and can know that you want Web expert. Core skills are PHP, CSS, JavaScript, HTML, MySQL. As a senior developer who has good experience in Web development, already More

€19 EUR in 2 days
(10 Reviews)

Hello, Thank you for posting your requirement here at Freelancer and I will be more than happy to assist you for the same We offer affordable and professional Website Design, SEO, SERM, Website Development and Mobile A More

€12 EUR in 7 days
(5 Reviews)

Hello Sir/Madam, I am an experienced web and graphic designer with a multi-skill set from design to development of Websites, Infographics, Brochures, packaging, eBooks, Logos, Business cards, Presentation Decks, Googl More

€19 EUR in 7 days
(5 Reviews)