Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : Sybase Functions : sybase_fetch_field

sybase_fetch_field

Get field information from a result (PHP 4, PHP 5)
object sybase_fetch_field ( resource result [, int field_offset] )


Code Examples / Notes » sybase_fetch_field

gray

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


anthony dot leung

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>";


Change Language


Follow Navioo On Twitter
sybase_affected_rows
sybase_close
sybase_connect
sybase_data_seek
sybase_deadlock_retry_count
sybase_fetch_array
sybase_fetch_assoc
sybase_fetch_field
sybase_fetch_object
sybase_fetch_row
sybase_field_seek
sybase_free_result
sybase_get_last_message
sybase_min_client_severity
sybase_min_error_severity
sybase_min_message_severity
sybase_min_server_severity
sybase_num_fields
sybase_num_rows
sybase_pconnect
sybase_query
sybase_result
sybase_select_db
sybase_set_message_handler
sybase_unbuffered_query
eXTReMe Tracker