how to get the column name

hi!
i want to display the database fields with the respective value...
like ,
my table is:pay_allow_details.
from that i have column name like :h_house_rent,hill_allow,risk_allow.
so i should display the value with the respective column name in jsp.
is there any query there for fetching the column name ?..
thank you,
kaleeswaran

re: how to get the column name

Hi.

You can use the SHOW COLUMNS statement to display column information: