Member Avatar for mortalex

Hey, i've got a problem, i'm trying to make a drop down box but so that the first value chosen automatically updates the fields that you can choose in the second drop down menu.

Yes this may seem easy, but the thing is that each values need to be populated from MySQL Db's.

The table is called PriceList, and the attributes are ID, Groupname, Itemname and Price.

The first drop down menu needs to be populated with Groupname, and then the second drop down menu with the Itemname.

Once the user has chosen the fields, a text box will be updated with the Price displayed.

I also need a button that adds another row of drop down menus, and a button that will delete a row.

If anyone could possibly show me a website or give me any pointers then that would be awesome, i'm just useless at JavaScript.

Cheers

  • 3 Contributors
  • 2 Replies
  • 135 Views
  • 3 Months Discussion Span
  • Latest Post Latest Post by samarinder

Recommended Answers

All 2 Replies

Member Avatar for DangerDev

use ajax to do that.
-as user select Groupname it should send request to the server through ajax,
-server will return values in the form of array or simply form all whole sub menu at server.
-use this value to form submenu.

Member Avatar for samarinder

Hi m also have the same problem, can u plz send me some details for doing this.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.