php how to print field names into an array

[gilgalbiblewhee]

how do you print field names of a db table into an array?

[curtiss]

You have two choices.

If you are going to be using these field names in conjunction with a regular recordset, you can always use a normal select statement (SELECT * FROM...) and use the mysql_fetch_assoc function to return an associative array of the field names and recordset. Then, just use array_keys to grab the field names out of the associative array that was returned.

Alternatively, you can use DESC [tablename] to show the properties of the table. Then, loop through the recordset that's returned from that and grab all of the array items with the key of "field".