Re: Result row count *without* buffering all results?

[Scott Gifford]

Ken Gieselman <ken@stripped> writes:

[...]

> So, here's my question: How can I find out how many rows are being
> returned by a query, without using mysql_stmt_store_result() to
> buffer all the rows back to the client?

One straightforward way is to replace the SELECT clause with just
SELECT COUNT(*) and execute that query first.

-----ScottG.