Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - Programming » SQL Anywhere Data Access APIs » SQL Anywhere PHP API » SQL Anywhere PHP API reference » Deprecated PHP functions


sqlanywhere_fetch_field (deprecated)

object sqlanywhere_fetch_field(  resource result_identifier [, field_offset ]  )

This function is deprecated. You should use the following PHP function instead: sasql_fetch_field.

Returns an object that contains information about a specific column.


result_identifier   The result resource returned by the sqlanywhere_query function.

field_offset   An integer representing the column/field on which you want to retrieve information. Columns are zero based; to get the first column, specify the value 0. If this parameter is omitted, then the next field object is returned.


An object that has the following properties:

  • id   contains the field/column number

  • name   contains the field/column name

  • numeric   indicates whether the field is a numeric value

  • length   returns field length

  • type   returns field type


This example shows how to use sqlanywhere_fetch_field to retrieve all the column information for a result set.

$result = sqlanywhere_query($conn, "SELECT GivenName, Surname FROM Employees");
while( ($field = sqlanywhere_fetch_field( $result )) ) {
        echo " Field ID = $field->id \n";
        echo " Field name = $field->name \n";
Related functions