|
|
|
|
Bookmark this on Delicious
Share on Facebook
 Slashdot It!
Digg  sybase_fetch_field
Get field information from a result
(PHP 4, PHP 5)
Code Examples / Notes » sybase_fetch_fieldgray
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
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 |
