pear NumRows

[Robert Fritz]

Hello,

i'm using pear (for the first time). the function "numRows" (Win XP
SP2 , IIS, MS ACCESS) gives me always the value "-1" (= the
ErrrorObject) - although the
sqlResult contains data.
I have to check the number of rows before I use the sqlResult. How do
I get the numbers of rows?

Something like this:
-------------------------------------------------
$intCounter=0;
while($row = $objSQLResult->fetchRow())
$intCounter++;
-------------------------------------------------
works fine, but when I want to use the sqlResult again,it seems to be
empty.

What can I do?

Thank you,
Robert

[Marcin Dobrucki]

Robert Fritz wrote:

i'm using pear (for the first time). the function "numRows" (Win XP
SP2 , IIS, MS ACCESS) gives me always the value "-1" (= the
ErrrorObject) - although the
sqlResult contains data.
I have to check the number of rows before I use the sqlResult. How do
I get the numbers of rows?

Something like this:
-------------------------------------------------
$intCounter=0;
while($row = $objSQLResult->fetchRow())
$intCounter++;
-------------------------------------------------
works fine, but when I want to use the sqlResult again,it seems to be
empty.

What can I do?

PEAR is a repository. What are you actually using? The DB package?
How are you using numRows()? It should be used something like this:

$res =& db->query("select * from foo");
$no_rows = $res->numRows();

You might want to start adding error checks into your code, a la the:

if (PEAR::isError($res)) {
die($res->getMessage());
}

/Marcin