Getting mysql table information with an empty table

[juxstapose]

How do I retrieve column information in php/mysql when the table is empty?

The functions below all require the use of a result pointer which is empty if there is no data in the table. Therefore I can not find out the column names.

mysql_num_fields
mysql_field_name
mysql_list_fields

Is there a way to do this?

Thanks

[urneegrux]

Instead of trying to get column names from an empty table, why not add a row of TEST values to your table, so you can just get use mysql_fetch_array() and get it from there?

-JPF