   #PHP Manual SESAM database functions SESAM database functions
   sesam_commit

   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.

   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() and sesam_execimm().
   ______________________________________________________________________

   Prev                     Home         Next
   SESAM database functions  Up  sesam_commit
