|
sqlanywhere_fetch_field
Prototype
object sqlanywhere_fetch_field( resource result_identifier [, field_offset ]
)
Description
Returns an object that contains information about a specific column.
Parameters
result_identifier The result identifier returned by a
sqlanywhere_query function.
field_offset An integer
representing the column/field on which you wish 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.
Returns
An object that has the following properties:
- id contains the field/column number
- name contains the field/column name
- numeric indicates whether or not the field is a numeric value
- length returns field length
- type returns field type
Example
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
sqlanywhere_data_seek
sqlanywhere_fetch_array
sqlanywhere_fetch_row
sqlanywhere_fetch_object
|
