PHP 7.0.6 Released

    sybase_fetch_field

    (PHP 4, PHP 5, PHP 7)

    sybase_fetch_field — Get 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

    User Contributed Notes

    anthony dot leung at virgin dot net
    12 years ago
    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>";
    gray at voicenet dot com
    16 years ago
    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
    To Top