Forum und email

sesam_affected_rows

(No version information available, might be only in CVS)

sesam_affected_rows — Get number of rows affected by an immediate query

설명

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.

매개변수

result_id

A valid result id returned by sesam_query().

반환값

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

예제

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";
?>