Selecting rows using a cursorslide 2 of 2

while ($row = ifx_fetch_row($statmt_id, ”NEXT” )) {

$serial_id = $row[serial_id];

$type_code = chop($row[type_code]);

$tape_num = $row[tape_num];

$title = chop($row[title]);

$hours = $row[hours];

$comment = chop($row[comment]);

echo "<tr>\n";

echo "<td><center>$serial_id</td>";

echo "<td><center>$type_code</td>";

echo "<td><center>$tape_num</td>";

echo "<td>$title</td>";

echo "<td>$hours</td>";

echo "<td>$comment</td>";

echo "<td>";

}

echo "</table>";

Demo 7

--- Continued from previous slide ---

Create an

“associative” array

named “row”.

Use column names

to identify fields.

Use “chop” to remove trailing blanks if desired.

Populate fields from associative array

Selecting rows using a cursor slide 2 of 2