ads_field

Retrieves the name of a field in a result set.

Syntax

string ads_field_name( resource result_id,

int field_number )

Parameters

result_id (I)	ID of a result set.
field_number (I)	Number of the field in the result set.

Remarks

ads_field_name returns the name of a field in a result set or returns False in the event of an error. The index of the first field of a result set is 1.

Example

echo "Connecting to Server \n";

$rConn = ads_connect( "DataDirectory=\\\\server1\\share1\\data\\;ServerTypes=2", "", "" );

echo "Connected \n";

echo "Selecting the customers table. \n";

$rResult = ads_do( $rConn, "SELECT * FROM customers" );

echo "Describing the customers table. \n";

$iNumFields =ads_num_fields( $rResult );

echo "The number of fields is: " . $iNumFields . " \n";

for ( $iField = 1; $iField < $iNumFields; $iField++ )

{

echo "Field Number: " . $iField . " \n";

$strField = ads_field_name( $rResult, $iField );

echo " Name: " . $strField . " \n";

$strField = ads_field_type( $rResult, $iField );

echo " Type: " . $strField . " \n";

$iFieldLen = ads_field_len( $rResult, $iField );

echo " Length: " . $iFieldLen . " \n";

$iFieldLen = ads_field_precision( $rResult, $iField );

echo " Precision: " . $iFieldLen . " \n";

$iFieldLen = ads_field_scale( $rResult, $iField );

echo " Scale: " . $iFieldLen. " \n";

}

echo "Closing the connection \n";

ads_close( $rConn );

echo "Disconnected \n";