Echo Database Field Names

[macleodjb]

Is there a way you can echo the field name that you have retrieved from your database query.

For instance, lets say i have a table that has "ItemNumber", "PartNumber", "Description".

I want to create a label using the same name as what's in the table. Can this be done?

[Brandoe85]

Check out SHOW COLUMNS:
http://dev.mysql.com/doc/refman/5.0/en/show-columns.html

Good luck.

/edit
Actually, not what you needed...might be helpful to someone though, nonetheless :)

[Fumigator]

If you use PHP you can use mysql_field_name() (http://us2.php.net/manual/en/function.mysql-field-name.php).

[Daemonspyre]

If you use ASP, you can use fld.name