PHP Manual
Prev |  | Next

# sesam_affected_rows

(PHP 3 CVS only)

sesam_affected_rows -- Get number of rows affected by an immediate query

## Description

int sesam_affected_rows ( string result_id)

`result_id` is a valid result id returned by sesam_query().

Returns the number of rows affected by a query associated with `result_id`.

The sesam_affected_rows() function can only return useful values when used in combination with "immediate" SQL statements (updating operations like `INSERT`, `UPDATE` and `DELETE`) because SESAM does not deliver any "affected rows" information for "select type" queries. The number returned is the number of affected rows.

See also: sesam_query() and sesam_execimm()

    $result = sesam_execimm ("DELETE FROM PHONE WHERE LASTNAME = '".strtoupper ($name)."'");
    if (!$result) {
        ... error ...
    }
    print sesam_affected_rows ($result).
        " entries with last name ".$name." deleted.\n"

Prev | Home | Next
SESAM database functions | Up | sesam_commit