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:[EMAIL PROTECTED]]
> Sent: 03 April 2001 23:59
> To: [EMAIL PROTECTED]; Mauricio Junqueira
> Subject: Re: [PHP] column names
>
>
> "Mauricio Junqueira" <[EMAIL PROTECTED]> 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/
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
