Select Column Names from a table

[stewartship]

Hi All,

Bit of a simple one but been away from the php mysql for awhile so... i need to retrieve all the actual column field names/titles from a db table (not the information stored within them), does anyone know the call to make this happen?

Thanks in advance for your help.

[Sxooter]

easiest way is to run a query like:

select * from table limit 1

and then use the php mysql_ functions that describe columns and what type they are. (i.e. mysql_list_fields() etc)