RE: [PHP] column names
| From: | Tim Ward | Date: | Thu, 05 Apr 2001 07:56:59 +0000 |
| Subject: | RE: [PHP] column names | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-47197@lists.php.net to get a copy of this message | ||
SHOW COLUMNS FROM tablename
is the MySQL query
Tim Ward
Senior Systems Engineer
Please refer to the following disclaimer in respect of this message:
http://www.stivesdirect.com/e-mail-disclaimer.html
> -----Original Message-----
> From: Steve Werby [mailto:steve-lists@befriend.com]
> Sent: 03 April 2001 23:59
> To: php-general@lists.php.net; Mauricio Junqueira
> Subject: Re: [PHP] column names
>
>
> "Mauricio Junqueira" <mauzero@netzero.net> wrote:
> > does anyone knows how to retrive information about the
> columns names of a
> > table?
>
> In MySQL use mysql_field_name(), in PostgreSQL use pg_fieldname().
>
> > I know that is possible to use show table mytable using isql but
> > I need to get information about the columns using sql.
> > that information is to be accessed with a php script. so,
> I'm looking
> > for something resembling "select info from table...."
>
> Check the online manual for more functions and other databases.
>
> --
> Steve Werby
> President, Befriend Internet Services LLC
> http://www.befriend.com/
>
>