db2_result

db2_result

Returns a single column from a row in the result set

 **db2_result** resource $stmt  $column

Use to return the value of a specified column in the current row of a result set. You must call before calling to set the location of the result set pointer. db2_result``db2_fetch_row``db2_result

stmt A valid resource. stmt

columnEither an integer mapping to the 0-indexed field in the result set, or a string matching the name of the column.

Returns the value of the requested field if the field exists in the result set. Returns null if the field does not exist, and issues a warning.

Voorbeeld: A example

The following example demonstrates how to iterate through a result set
with  and retrieve columns from the
result set with .

db2_fetch_row``db2_result

<?php
$sql = 'SELECT name, breed FROM animals WHERE weight < ?';
$stmt = db2_prepare($conn, $sql);
db2_execute($stmt, array(10));
while (db2_fetch_row($stmt)) {
    $name = db2_result($stmt, 0);
    $breed = db2_result($stmt, 'BREED');
    print "$name $breed";
}
?>

cat Pook
gold fish Bubbles
budgerigar Gizmo
goat Rickety Ride

db2_fetch_array``db2_fetch_assoc``db2_fetch_both``db2_fetch_object``db2_fetch_row