Multiple Dynamic Dropdowns from Database

I am working on a web-based incident tracking system.

For the incidents, there will be 3 tiers. A primary "Class", a "sub-class" and a "type." I need three pulldown menus, populated from a MySQL database. First, the client will choose the class, then, based on that selection, sub-classes will appear. Then, based on the sub-class chosen, a list of "types" will appear. What is critical is that these items be queried from the database once when the page is called, and no refreshes are necessary. For this, I'll need some sort of client side script which I am not familiar with. I want the client to be able to add their own Classes, Sub-classes, and Types. Essentially I need a client side script to change the menus once a selection has been made and for all those values to be populated from a server side PHP script.

Each tier has its own MySQL table. Classes have unique ID numbers, which should be the value of the form, sub-classes have their own ID numbers and have a CLASS_PARENT_ID which relates to the above tier, and types have their own ID numbers and have a SUB_CLASS_PARENT_ID which likewise relates to the above tier.

It doesn't need to look nice or anything. Just three dynamic, database-driven pulldowns, the designing will happen later.

I'm sure this is a very simple project, but I may not be explaining it well. Please ask any questions.

Skills: AJAX, Javascript, MySQL, PHP

See more: i need a script writer, multiple choice database questions, need php script installed, php, mysql, website design, ajax, javascript, mobile phone, angular.js, laravel, web development, jquery, need php script increasing twitter followers, need php script calculate leave days, need php script captcha decoder, update database csv file php script, dynamic keyword insertion landing page php script, need php script expert, dynamic search database using ajax php

About the Employer:
( 1 review ) Las Vegas, United States

Project ID: #17115028

Awarded to:


Hi Greetings!! This is not a complicated task. I have done such things in my previous projects. I can do this in few hours or may be in few min. I have the logic that how can i do this. ⭐⭐My understanding abou More

$25 USD in 1 day
(21 Reviews)

17 freelancers are bidding on average $43 for this job


Hello, My name is Sergey. I am Freelancer from [login to view URL], Russia. I can quickly help you as PHP/MySQL/AJAX programmer to create 3 tier dependents dropdowns. Class -> SubClass -> Types. Can be done today. 1 More

$50 USD in 1 day
(1784 Reviews)

I understand your requirements fully and would like to do it for you. I have done this in many sites. Please reply me to discuss more.

$25 USD in 1 day
(63 Reviews)

Dear Sir/Madam, I have 7+ years Experience in Web-Design and Web-Development.I building different types of Web Site (Ecommerce,Classified,Realstate,Weding,Porn,Personal,Dating,Event Management...etc ). I reading More

$158 USD in 1 day
(75 Reviews)

How are you. I did review your requirements. Can you explain detaily. Please discuss with me. -----------

$35 USD in 1 day
(75 Reviews)

Hi I am PHP, Wordpress, Ionic, Angular, Laravel and Codeigniter developer. I can deliver your project in given time and budget. I can immediately start to work on your project. My Skills are WordPress, Lar More

$100 USD in 2 days
(24 Reviews)

Hello I can help you to get it done quickly. I have 10+ years experience in php/mysql development. Thanks Guru Venkat

$25 USD in 1 day
(42 Reviews)

i done other work similar to your task for select are : select state then district then community so i sure to done it fast

$25 USD in 1 day
(13 Reviews)

Hello, as you can see by viewing my profile I did many successful projects in the past but took a long break from the site. However, I’ve kept a day job in the field this whole time. Life’s circumstances changed and More

$25 USD in 1 day
(9 Reviews)
$30 USD in 1 day
(19 Reviews)

Hello, How are you. I read your job detail carefully. I have many experience in developing such as one. I can make you satisfied in all needs. I can finish quickly. If you hire me, I will do my best. My favorite More

$30 USD in 1 day
(5 Reviews)
$88 USD in 1 day
(3 Reviews)

Hi there! I am interested in your job and did similar kind of work many times. I will use AJAX and DOM manipulation for this purpose. I will use Jquery if you do not mind. I can also do with JavaScript it may take few More

$15 USD in 0 days
(4 Reviews)

Hello, Can we discuss the project details over chat please? I am MS full stack developer having expertise in developing Web , desktop and mobile applications using MS stack. I am offering my services for this jo More

$30 USD in 1 day
(4 Reviews)

hello, I have experience to do what you need, create 3 linked menu with mysql, dynamic content according to the selection in the previous menus

$25 USD in 1 day
(0 Reviews)

I will do this task maximum 2 days. and i have done this type of task many times. so i will do this task very best....

$25 USD in 2 days
(0 Reviews)
$15 USD in 1 day
(0 Reviews)