IFX_FIELDPROPERTIES(3)							 1						    IFX_FIELDPROPERTIES(3)

ifx_fieldproperties - List of SQL fieldproperties

SYNOPSIS

       array ifx_fieldproperties (resource  $result_id)

DESCRIPTION

	Returns  the  Informix	SQL  fieldproperties  of  every  field	in  the  query	as  an associative array. Properties are encoded as: "SQL-
       TYPE;length;precision;scale;ISNULLABLE" where SQLTYPE = the Informix type like "SQLVCHAR" etc. and ISNULLABLE = "Y" or "N".

PARAMETERS

	      o $result_id
		-$result_id is a valid resultid returned by ifx_query(3) or ifx_prepare(3) (select type queries only!).

RETURN VALUES

	Returns an associative array with fieldnames as key and the SQL fieldproperties as data for a query  with  $result_id.	Returns  FALSE	on
       errors.

EXAMPLES

       Example #1

	      Informix SQL fieldproperties

	      <?php
	      $properties = ifx_fieldproperties($resultid);
	      if (!isset($properties)) {
		  /* ... error ... */
	      }
	      foreach ($properties as $fname => $val) {
		  echo "$fname:	 property = $val
";
	      }
	      ?>

SEE ALSO

       ifx_fieldtypes(3).

PHP Documentation Group 												    IFX_FIELDPROPERTIES(3)