PHP: sybase_fetch_field - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

sybase_fetch_object sybase_fetch_assoc

Last updated: Fri, 26 Jan 2007

view this page in

# sybase_fetch_field

(PHP 3, PHP 4, PHP 5)

sybase_fetch_field -- Get field information from a result

## 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
sybase_fetch_field
anthony dot leung at virgin dot net
25-Jun-2003 11: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
15-Oct-1999 03: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
sybase_fetch_object sybase_fetch_assoc

Last updated: Fri, 26 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST