Microsoft Word - Core PHP Programming Using PHP to Build Dynamic Web Sites

// execute query
$Query = "SELECT name, price ";
$Query .= "FROM catalog ";
$Result = odbc_do($Connection, $Query);

print(odbc_field_len($Result, 1));

odbc_close($Connection);
?>

string odbc_field_name(integer result, integer field)

Use odbc_field_name to get the name of a field in a result set. Fields are numbered
starting with one.

<?
// connect to database
$Connection = odbc_connect("store", "guest", "guest");

// execute query
$Query = "SELECT name, price ";
$Query .= "FROM catalog ";
$Result = odbc_do($Connection, $Query);

print(odbc_field_name($Result, 1));

odbc_close($Connection);
?>

string odbc_field_type(integer result, integer field)

Use odbc_field_type to get the type of a field in a result set. Fields are numbered
starting with one.

<?
// connect to database
$Connection = odbc_connect("store", "guest", "guest");

// execute query
$Query = "SELECT name, price ";
$Query .= "FROM catalog ";
$Result = odbc_do($Connection, $Query);

print(odbc_field_type($Result, 1));

odbc_close($Connection);
?>