sybase_fetch_field

(PHP 4, PHP 5)

sybase_fetch_fieldGet field information from a result

Description

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

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

Parameters

result

field_offset

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

Return Values

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

See Also

Коментарии

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
1999-10-15 18:27:18
http://php5.kiev.ua/manual/ru/function.sybase-fetch-field.html
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>";
2003-06-25 14:44:59
http://php5.kiev.ua/manual/ru/function.sybase-fetch-field.html

    Поддержать сайт на родительском проекте КГБ