i have a question to ask regarding the web form which i want to do.
i have a form which there is a few column to let user to fill in. Some are text box and some are dropbox which the datat is from my database.
product name, product price quantity and amount
product name and product price is where user able to select which base on my mysql database table. quantity is where user must key in and the amount is auto generate which is base on product price X quantity. so far everything is going well.
But there is a problem on my drop box selection. when i select product name, it will show which product is available to select. this is fine. but i would like my product price will be automatic shown base on the product name choose. i do not want the product price also in drop box style. what i want is when the user choose the product name, than the product price will be automatic shown in another column. after that, when user key in the quantity, the amount is automatic shown(this has been completed on previous post.) So How can i manage it?