How to retrive field name from database?

[nunos]

I would like to know if it is possible to, trough a php mysql command, get an array with the name of the fields of a table from the database.

 

Thanks 

[kickstart]

Hi

 

You can use mysql_ num_ fields() and mysql_ field_ name(). This would give you an array:-

 

$fieldNameArray = array();
for($aCnt = 0;$aCnt<mysql_ num_ fields($rs);$aCnt++) $fieldNameArray[]=mysql_ field_ name($rs,$aCnt);

 

although as you can no doubt see you can get the field names anyway if you know their offset.

 

All the best

 

Keith