Steve Werby wrote:
> "Tim Ward" <[EMAIL PROTECTED]> wrote:
>> SHOW COLUMNS FROM tablename
>> is the MySQL query
>
> That works well from the MySQL commandline, but isn't as useful from
> within a PHP script if Mauricio wants to control the formatting of it,
> limit the
> fields displayed and use it within the logic of the PHP script. Depends
> what he needs to do. I still think mysql_field_name() / pg_fieldname()
> are the way to go, though Mauricio never mentioned which DBMS he's using.
>
> --
> Steve Werby
> President, Befriend Internet Services LLC
> http://www.befriend.com/
>
>
>
I am using interbase6....
By now , using this query over the system tables solved my problem:
SELECT RDB$FIELD_NAME
FROM RDB$RELATION_FIELDS
WHERE RDB$RELATION_NAME = 'mytable'
I need to do this way because the table might be empty and I'll not be
able to use ibase_field_info on each column returned by one query like
select * from mytable.
--
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]
