PHP~MYSQL - Get list of all the fields within a table

[cksraj]

Hi

I would like to get list of all the fields in a table. Is there any command available in MYSQL (Or) PHP.

Thanks
Jarrelva

[Carpetsmoker]

You mean something like:

# mysql
mysql> use database_name;
mysql> describe table_name;

[cksraj]

describe table_name; - gives all details about table like Field, Type, Null, Key, etc... I want to get only Field from the result set, that is Field Name from a table. Is there any command (OR) function available in mysql?