Link to home
Start Free TrialLog in
Avatar of chefmgbrown
chefmgbrown

asked on

how to populate a combobox from mysql database and then populate a second and third combobox based on selection from first and second combobox (using php and mysql database

I have three tables
manufacturers (id, manuf_name)
cigar_lines(line_id,line_name, id) id is foreign key from manufacturer table
details(detail_id,details,line_id) line_id is foreign key from cigar_lines table

The first combobox needs to get values from the manufacturers table. I want the user to select a manufacturer, have the second combobox populate with all the cigar lines made from that manufacturer(line_name), and then the third combobox populate with all the cigars within the chosen line(details). Any help would be greatly appreciated.
ASKER CERTIFIED SOLUTION
Avatar of Roger Baklund
Roger Baklund
Flag of Norway image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chefmgbrown
chefmgbrown

ASKER

Excellent answer. Thanks