sybase_fetch_field()

(PHP 4, PHP 5)

Get field information from a result

Warning
This function wasREMOVEDin PHP 7.0.0.

说明

sybase_fetch_field(resource $result[,int $field_offset= -1]): object

sybase_fetch_field() can be used in order to obtain information about fields in a certain query result.

参数

$result
$field_offset: If the field offset isn't specified, the next field that wasn't yet retrieved by sybase_fetch_field() is retrieved.

返回值

Returns an object containing field information.

The properties of the object are:

name - column name. if the column is a result of a function, this property is set to computed#N, where #N is a serial number.
column_source - the table from which the column was taken
max_length - maximum length of the column
numeric - 1 if the column is numeric
type - datatype of the column

参见

sybase_field_seek()Sets field offset

Bit short on comments and tips bout this one so head down to mysql_fetch_fields where the concept is the same. I seemed to get an infinite loop over there using the $i counter tho, so I used a for loop instead. 
The list of properties you can get from what I've called $info is in the example to the mysql equivalent.
//start of an example to print out column headings
echo "<table><tr>";
 $numfields=sybase_num_fields($query);
 for ($f=0;$f<=$numfields;$f++){
  $info = sybase_fetch_field($query);
  echo "<td> $info->name </td>";
 }
 echo "</tr><tr>";

The 'type' field contains (roughly) the datatype of the source column. Types returned are:
 'type'  Sybase Type
 ------- --------------------------
 string  CHAR, VARCHAR, TEXT
 image  IMAGE
 blob   BINARY, VARBINARY
 bit   BIT
 int   TINYINT, SMALLINT, INT
 real   REAL, FLOAT, NUMERIC, DECIMAL
 money  MONEY
 datetime DATETIME, SMALLDATETIME