> include 'db.php';
> $db = DB::connect($dsn);
> $strSQL = "SELECT * FROM {Table}";
> $row = $db->getRow($strSQL, DB_FETCHMODE_ASSOC);
>
> $field_names = array_keys($row);
>
> Iterate $field_names for the field names from the table. This should work for
> any database that PHP can use.
Just a wo
ames for everything in that table.
>
> Does that answer your question or are you looking for something else?
>
> Dave
>
> -Original Message-
> From: R.S. Herhuth [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 16, 2002 2:07 AM
> To: [EMAIL PROTECTED]
> Su
s that answer your question or are you looking for something else?
Dave
-Original Message-
From: R.S. Herhuth [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 2:07 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Getting Field Names in Microsoft SQL
I'm trying to build a dynamic
I'm trying to build a dynamic script that basically extracts all of the
fields in a MS SQL database...I just can't seem to figure out how to get
at the field names themselves. I am using the mssql_fetch_array
followed by the $row['field_name'] in an array. But I would like to
make the field_nam
