Subject Re: [firebird-php] ibase_num_rows instead of count(*)
Author Lester Caine
Almond wrote:

> I do know that kind of trick, but it only return the total record count. I
> want to show the user the no. of record their query returns :(.

THAT is a different problem. There has been some work on returning the
number of rows affected in PHP5 !

From the manual ...
Note: In PHP 5.0.0 and up, this function returns the number of rows
affected by the query (if > 0 and applicable to the statement type). A
query that succeeded, but did not affect any rows (e.g. an UPDATE of a
non-existent record) will return TRUE.
That applies to updates and is also returned as ibase_affected_rows, but
if using SELECT, then it depends if you download all the rows, in which
case you just read the count of number of records downloaded.

Lester Caine
L.S.Caine Electronic Services