Re: Way to use count() and LIMIT?

"SHELTON,MICHAEL (Non-HP-Boise,ex1)" <michael_shelton@non.hp.com> writes:

> Sorry I haven't been able to get back to you -- busy at work.
>
> One last comment to try is in MS SQL you can get the number of rows returned
> via @@ROW_COUNT -- however I couldn't find the equivalent for PG SQL
> (doesn't mean there isn't one).
>
> Anyone else know what might work here?  The important detail is wanting to
> get a number of rows in the _result_ not necessarily the table.

libpq gives you this information via the PQntuples() function.
Whether PHP gives you access to that info I don't know--see your docs.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863