Re: Get Names of columns of a table
| From: | mike karthauser | Date: | Wed, 17 Dec 2003 13:34:01 +0000 |
| Subject: | Re: Get Names of columns of a table | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32102@lists.php.net to get a copy of this message | ||
> is there a PHP function that wil return the names of the columns for a given
> table?
You need to use an SQL function called DESCRIBE
http://www.mysql.com/doc/en/DESCRIBE.html
HTH
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> mikek@brightstorm.co.uk
Web >> http://www.brightstorm.co.uk
Tel >> 0117 9426653 (office)
07939 252144 (mobile)
Snailmail >> Unit 8, 14 King Square,
Bristol BS2 8JJ