How do I display result when selected from drop down list

[jamesnkk]

Hi,

I have a table consist of 3 columns, the 1st column which I already populate into a drop down list, when the user select the product item from drop down list, It immediately display the price on the 2nd column like an invoice.

How can I do it in Php and mysql , any advise from the experts out there .
Your contributions and advise is very important to me.