sybase_fetch

Description

object sybase_fetch_field ( resource result [, int field_offset] )

Returns an object containing field information.

sybase_fetch_field() can be used in order to obtain information about fields in a certain query result. If the field offset isn't specified, the next field that wasn't yet retrieved by sybase_fetch_field() is retrieved.

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 sybase_field_seek().

add a note User Contributed Notes

anthony dot leung at virgin dot net
26-Jun-2003 02:44


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-Oct-1999 06:27


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

add a note