Cancelled

DropDown menus

Hi First of all i apologise for my English

The project is small

I have already a MySQl database (db#1) with many games from soccer (from 10-600 max)

The name of db is 'test' I have a table in db with name 'games'

The fields of the table 'games' has the following format

gam_id int Unsigned prim Key

gam_date date

gam_time time

team1 VARCHAR(30)

team2 VARCHAR(30)

league VARCHAR(10)

p1 decimal(4,2)

pX decimal(4,2)

p3 decimal(4,2)

pov decimal(4,2)

pund decimal(4,2)

I want to make a web page which has 2 dropdown menus

In dropdown menu[#1] The user must make a choice of one league for example ENG_PR

with Leagues (For example ENG_PR, FR1, SP1, SP2 etc) but only with leagues which are in db[#1]

Not all the leagues in the world and not duplicated

Also there is a second dropdown menu[#2] from which the user make the choice date of games For example 19-01-2018

The query returns all games which are in league in dropdown menu[#1] and play in date which is in dropdown menu[#2]

(In the above 2 dropdown menu i want to have each one the 1st choice is "ALL" which appear all results without filter)

I want when a user make a choice in that 2 menus the result data (query) from db#1 go to a third dropdown menu[#2]

I want only that fields go to the third dropdown menu[3]

gam_id int Unsigned prim Key

gam_date date

gam_time time

team1 VARCHAR(30)

team2 VARCHAR(30)

league VARCHAR(10)

Thats all

I want this project to work localy in my computer (localhost)

Dont care about design of html or php pages Put only one title in the start and the end of every page and titles in fields (Maybe little description when is necessary)

------------------------------------------------------

I use Windows 10 (32bit) - Apache 2.4.29 - PhP 5.6.33 - MySQL 5.7.20 - jQuery 3.2.1

I have installed Apache in folder C:/Apache24

The time period to finish that work is about 10 days Please tell me if you agree. thank you

Skills: .NET, C# Programming, iPhone, Software Architecture, Visual Basic

See more: drop down menu javascript, dropdown menu html, drop down menu jquery, html dropdown form, drop down navigation menu html, horizontal drop down menu css, drop down menu bootstrap, drop down menu in html on mouseover, Magento, PHP, HTML, Design Website, WordPress, php, html, design, website baker pages php html, php html email design, php html webmail design, php mysql classifieds sripts css html design, build html pages php automatic

About the Employer:
( 0 reviews ) Greece

Project ID: #16105697

1 freelancer is bidding on average €60 for this job

VirtuosoIT

Hired by the Employer

€60 EUR in 3 days
(7 Reviews)
4.0