Author Topic: read the list of column names into a recordset  (Read 956 times)

0 Members and 1 Guest are viewing this topic.

Offline vauneenTopic starter

  • Irregular
  • Posts: 14
    • View Profile
read the list of column names into a recordset
« on: October 31, 2003, 09:51:45 AM »
hi,
i need to read the column headings (not the values in them) of a certain MySQL table into a recordset using PHP, does anyone know how/if i can do it?

vauneen                    

Offline vauneenTopic starter

  • Irregular
  • Posts: 14
    • View Profile
read the list of column names into a recordset
« Reply #1 on: October 31, 2003, 10:10:15 AM »
just figured it out, sorry, posted too soon.

this seems to be working:
SHOW FIELDS FROM databasename.tablename

vauneen