ifx_htmltbl_result(3) php man page | unix.com

IFX_HTMLTBL_RESULT(3)							 1						     IFX_HTMLTBL_RESULT(3)

ifx_htmltbl_result - Formats all rows of a query into a HTML table

SYNOPSIS
       int ifx_htmltbl_result (resource  $result_id, [string  $html_table_options])

DESCRIPTION
	Formats and prints all rows of the $result_id query into a HTML table.

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

	      o $html_table_options
		- This optional argument is a string of <table> tag options.

RETURN VALUES
	Returns the number of fetched rows, or FALSE on errors.

EXAMPLES
       Example #1

	      Informix results as HTML table

	      <?php
	      $rid = ifx_prepare ("select * from emp where name like " . $name,
				   $connid, IFX_SCROLL);
	      if (! $rid) {
		  /* ... error ... */
	      }
	      $rowcount = ifx_affected_rows ($rid);
	      if ($rowcount > 1000) {
		  printf ("Too many rows in result set (%d)
<br />", $rowcount);
		  die ("Please restrict your query<br />
");
	      }
	      if (! ifx_do($rid)) {
		  /* ... error ... */
	      }

	      ifx_htmltbl_result ($rid, "border="2"");

	      ifx_free_result($rid);
	      ?>

PHP Documentation Group 												     IFX_HTMLTBL_RESULT(3)