Collections:
mssql_field_name() - Retrieve Field Names
How To List All Field Names in the Result Set using mssql_field_name()?
✍: Guest
The result set object returned by a SELECT statement also contains column (field) names, lengths and types. You can use mssql_field_name(), mssql_field_length() and mssql_field_type() to get those information. The tutorial exercise below shows a good example:
$con = mssql_connect('LOCALHOST','sa','FYIcenter'); mssql_select_db('FyiCenterData', $con); $sql = "SELECT * FROM sys.objects" . " WHERE type_desc='USER_TABLE'"; $res = mssql_query($sql, $con); print("Result set columns:\n"); for ($i=0; $i<mssql_num_fields($res); $i++) { print(" ".mssql_field_name($res,$i)); print(", ".mssql_field_type($res,$i)); print(", ".mssql_field_length($res,$i)."\n"); } mssql_free_result($res); mssql_close($con);
Run this PHP script, you will see a list columns (fields):
Result set columns: name, char, 255 object_id, int, 4 principal_id, int, 4 schema_id, int, 4 parent_object_id, int, 4 type, char, 2 type_desc, char, 120 create_date, datetime, 8 modify_date, datetime, 8 is_ms_shipped, bit, 1 is_published, bit, 1 is_schema_published, bit, 1
⇒ SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows
⇐ mssql_result() - Retrieve Field Values
⇑ SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution
2024-03-23, 1328🔥, 0💬
Popular Posts:
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...