Re: Get Names of columns of a table
| From: | CPT John W. Holmes | Date: | Wed, 17 Dec 2003 15:09:27 +0000 |
| Subject: | Re: Get Names of columns of a table | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32105@lists.php.net to get a copy of this message | ||
From: <jeffrey_n_Dyke@Keane.com>
> > is there a PHP function that wil return the names of the columns for a
> > given table?
> http://www.php.net/mysq_list_fields
Note: The function mysql_list_fields() is deprecated. It is preferable to
use mysql_query() to issue a SQL SHOW COLUMNS FROM table [LIKE 'name']
Statement instead.
Even if you're not using MySQL, the database should have a SHOW query or an
equivilent.
---John Holmes...