Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
sesam_affected_rows
OuSob Home Page
PrevNext

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 )

Gets the number of rows affected by an immediate query.

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.

Parameters

result_id

A valid result id returned by sesam_query().

Return Values

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

Examples

Example 1. sesam_affected_rows() example

<?php
$result = sesam_execimm("DELETE FROM PHONE WHERE LASTNAME = '" . strtoupper($name) . "'");
if (!$result) {
    /* ... error ... */
}
echo sesam_affected_rows($result).
    " entries with last name " . $name . " deleted.\n";
?>

See Also

sesam_query()
sesam_execimm()

PrevHomeNext
SESAM Database FunctionsUpsesam_commit