Database jargon can always be a factor in clear communication, so I'll be careful in my suggestions. I take your question to mean: "how do I return the column names from any given table within MS SQL?" If that's what you want, you need to select information from the [syscolumns] table in your database context. Example: " select * from [syscolumns] where id = 693577509 ". I collected the table id 693577509 from [sysobjects], which keeps a record of table name and system id for that table. This gives me the column names 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] Subject: [PHP-WIN] Getting Field Names in Microsoft SQL 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_name dynamic (i.e. not knowing the field_names ahead of time) which would make the script adaptable to any table in the database. So if I get the field's value by $row['field_name'] how do I get at the field's name? thanks, Ron -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
