Dynamic drop down box, populated from MySQL Db

Please support our JavaScript / DHTML / AJAX advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Reply

Join Date: Oct 2007
Posts: 30
Reputation: mortalex is an unknown quantity at this point 
Solved Threads: 0
mortalex mortalex is offline Offline
Light Poster

Dynamic drop down box, populated from MySQL Db

 
0
  #1
Feb 25th, 2008
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
Reply With Quote Quick reply to this message  
Join Date: Jan 2008
Posts: 483
Reputation: DangerDev has a spectacular aura about DangerDev has a spectacular aura about 
Solved Threads: 58
DangerDev's Avatar
DangerDev DangerDev is offline Offline
Posting Pro in Training

Re: Dynamic drop down box, populated from MySQL Db

 
0
  #2
Feb 25th, 2008
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.
Freedom in the Mind, Faith in the words.. Pride in our Souls...
Indian Developer
http://falaque.wordpress.com/
Reply With Quote Quick reply to this message  
Join Date: Oct 2007
Posts: 17
Reputation: samarinder is an unknown quantity at this point 
Solved Threads: 0
samarinder samarinder is offline Offline
Newbie Poster

Re: Dynamic drop down box, populated from MySQL Db

 
0
  #3
Jun 25th, 2008
Hi m also have the same problem, can u plz send me some details for doing this.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the JavaScript / DHTML / AJAX Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC