Selecting rows Output to a HTML table.

<?php

$statmt_txt = "select tape_num Tape_Number ,title from vhs where type_code = 'ST1' order by title";

$statmt_id = ifx_prepare($statmt_txt,$connect_id,IFX_SCROLL); // PREPARE

if (!$statmt_id) { chk_ifx_err1($statmt_id); } // CHECK FOR ERROR

$ret_val = ifx_do($statmt_id); // EXECUTE PREPARED STATEMENT

if (!$ret_val) { chk_ifx_err1($statmt_id); } // CHECK FOR ERROR

ifx_htmltbl_result ($statmt_id,

"BORDER='1' CELLSPACING=0 CELLPADDING=2 BGCOLOR='cornsilk' ALIGN=center");

Demo 6

See output on next slide

Use display label for clarity