note 113709 added to function.mssql-field-name

There is a limitation of 30 characters for the field name. So if your query has fieldname AS really_long_overly_descriptive_name, you will only get really_long_overly_descriptiv back <?php // Send a select query to MSSQL $query = mssql_query('SELECT [username] AS [really_long_overly_descriptive_name], [name], [email] FROM [php].[dbo].[userlist]'); echo 'Result set contains the following field(s):', PHP_EOL; // Dump all field names in result for ($i = 0; $i < mssql_num_fields($query); ++$i) { echo ' - ' . mssql_field_name($query, $i), PHP_EOL; } // Free the query result mssql_free_result($query); ?> Outputs the following: Result set contains the following field(s): - really_long_overly_descriptiv - name - email ---- Server IP: 64.71.164.2 Probable Submitter: 195.130.159.146 ---- Manual Page -- http://php.net/manual/en/function.mssql-field-name.php Edit -- https://master.php.net/note/edit/113709 Del: integrated -- https://master.php.net/note/delete/113709/integrated Del: useless -- https://master.php.net/note/delete/113709/useless Del: bad code -- https://master.php.net/note/delete/113709/bad+code Del: spam -- https://master.php.net/note/delete/113709/spam Del: non-english -- https://master.php.net/note/delete/113709/non-english Del: in docs -- https://master.php.net/note/delete/113709/in+docs Del: other reasons-- https://master.php.net/note/delete/113709 Reject -- https://master.php.net/note/reject/113709 Search -- https://master.php.net/manage/user-notes.php