ibase_name_result

ibase_name_result

Assigns a name to a result set

bool **ibase_name_result** resource $result string $name

This function assigns a name to a result set. This name can be used later in UPDATE|DELETE ... WHERE CURRENT OF statements. name

resultAn InterBase result set.

nameThe name to be assigned.

return.success

Voorbeeld: example

<?php
$result = ibase_query("SELECT field1,field2 FROM table FOR UPDATE");
ibase_name_result($result, "my_cursor");

$updateqry = ibase_prepare("UPDATE table SET field2 = ? WHERE CURRENT OF my_cursor");

for ($i = 0; ibase_fetch_row($result); ++$i) {
    ibase_execute($updateqry, $i);
}
?>

ibase_prepare``ibase_execute