Returns the row count of a cursor.

Syntax

---

edb_rowcount(<CursorHandle>)

<CursorHandle> =

Handle of cursor returned by edb_execute function

Returns

---

Cursor row count (INTEGER) if successful, or FALSE if there are any errors

Usage

---

The edb_rowcount function returns the number of rows present in a cursor. The row count can change depending upon whether there is an active filter and/or range present on the cursor.

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
// the result set cursor row count

$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_rowcount($cursor);

edb_disconnect($con);
?>