   #PHP Manual Informix functions ifx_getsqlca ifx_nullformat

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                              ifx_htmltbl_result

   (PHP 3>= 3.0.3, PHP 4 )
   ifx_htmltbl_result --  Formats all rows of a query into a HTML table

Description

   int ifx_htmltbl_result ( int result_id [, string html_table_options])

   Returns the number of rows fetched or FALSE on error.

   Formats all rows of the result_id query into a HTML table. The
   optional second argument is a string of <table> tag options

   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)\n<br />", $rowcount);
       die ("Please restrict your query<br />\n");
   }
   if (! ifx_do($rid)) {
       /* ... error ... */
   }
   ifx_htmltbl_result ($rid, "border=\"2\"");
   ifx_free_result($rid);
   ?>
   ______________________________________________________________________

   Prev         Home           Next
   ifx_getsqlca  Up  ifx_nullformat
