Lester Caine 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 !

It is very simple. Firebird does *not* provide any means to know how
many record are available in the dataset. I even believe that the engine
is designed that way, that in many cases it doesn't know either...

OTOH, Firebird does provide the way to count number of rows *affected*
by and UPDATE, DELETE and INSERT (with SELECT) statements, and that
feature has been there since InterBase6 (or even earlier), just now it
is going to be exposed in PHP5.

Hope this clears things a bit.

Regards,

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org