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, 1244🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...