I have a drop down list that is populated with a column “product_name” from a database “products”.
Each of these products has a finish level, “good”, “better”, “best” with a different price associated with that level. (i.e. product 1 has 3 different prices in 3 separate columns)
I would like to have radio buttons labeled “good”, “better”, “best” underneath the drop down that take the selected “product name” and look up the price in the database table associated with the selected radio button finish level and place that value into a text box underneath the radio buttons that the user can see, but obviously not edit.
I would want it to refresh in real time if the user changes the selection of the drop down menu.
This is all on a form that is submitted at the end to a php page that does some math to make an invoice.