Returns the number of rows affected by, or returned by, a command.

Syntax

---

edb_rowsaffected(<CommandHandle>)

<CommandHandle> =

Handle of command returned by edb_prepare function

Returns

---

Rows affected (INTEGER) if successful, or FALSE
if there are any errors

Usage

---

The edb_rowsaffected function returns the number of rows affected for any SELECT, INSERT, UPDATE, or DELETE statement.

Examples

---

<?php

// The following script connects to an ElevateDB
// Server and database, prepares a parameterized
// SELECT statement, sets the parameter values,
// executes the statement, and then displays the
// number of affected rows

$con = edb_connect("type=remote;charset=Ansi;address=127.0.0.1;"+
                   "uid=Administrator;pwd=EDBDefault;database=Test");
if (!$con)
  {
  die("Could not connect: " . edb_errmsg());
  }

$cmd = edb_prepare($con,"SELECT * FROM customer WHERE State=:State");
edb_setparam($cmd,"State","FL");
$cursor = edb_execute($cmd,TRUE);

echo edb_rowsaffected($cmd);

edb_disconnect($con);
?>