Alternativly i found you can always do it like this using the foreach() loop...
$types = @ifx_fieldtypes($resultid);
if (isset($types))
{
foreach($types as $field_name => $data_type)
{
echo "{$field_name} {$data_type}";
}
}
ifx_fieldtypes
(PHP 4, PHP 5 < 5.2.1)
ifx_fieldtypes — List of Informix SQL fields
Description
ifx_fieldtypes
( resource
$result_id
) : array
Returns an associative array with fieldnames as key and the SQL
fieldtypes as data for the query associated with
result_id.
Parameters
-
result_id -
result_idis a valid resultid returned by ifx_query() or ifx_prepare() (select type queries only!).
Return Values
Returns an associative array with fieldnames as key and the SQL
fieldtypes as data for query with
result_id. Returns FALSE on error.
Examples
Example #1 Fieldnames and SQL fieldtypes
<?php
$types = ifx_fieldtypes($resultid);
if (is_array($types)) {
foreach ($types as $fname => $val) {
echo "$fname:\t type = $val\n";
}
}
?>
add a note
User Contributed Notes 1 note
lord_edd at hotmail dot com ¶
22 years ago
