need help in fetching record from mysql in forms

[meaashish]

hello friends ,I want to get a solution of following problem

I have a table in mysql database. which contains 4 columns
*id
*productname
*productdescription
*productprice

one of my pages have a form which allow to choose the productname.

what i want when user select the productname in select menu, then other 2 menus dynamically fetch its description and price in other form fields.

can someone plz help me with a small script.

Thanking you

[vaayaaedu]

You will need AJAX to solve the issue. Let me know if u face any problem.