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_n ame, 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.
manufacturers (id, manuf_name)
cigar_lines(line_id,line_n
details(detail_id,details,
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER