Posted by Kim on 11/30/07 12:40

I ended up with using 2 queries, first one giving only a count result
(FetchColumn) and the second to give the actual content (loop with
Fetch).

I never got PHP to create a SQLite PDO object, and I had enabled both
required dlls (php_pdo.dll and php_pdo_sqlite.dll) in php.ini.

OLLi: Exactly how am I not using non-PDO functions ? numRows() is
listed as a PDO function on www.php.net.

On Nov 22, 12:24 am, Oliver Grätz <oliver.gra...@gmx.de> wrote:
> Kim schrieb:
>
> > I keep getting "function not defined" when trying to get a result
> > count on my queries ("numRows()") and dont see a bug report on PHP.net
> > on this matter. And yes, my queries DO have results.
> > Any idea why I get that message ?
>
> First of all, you are using non-PDO functions in a PDO context. And
> then, even rowCount won't help you because for most backend it only
> tells you how many rows were AFFECTED by your query (INSERT, UPDATE,
> ...) not the number of rows that were RETURNED (SELECT). PDO does not
> feature any numrows-capabilities, even if the backend does. You have to
> resort to one of two solutions:
>
> 1. Use fetchAll() followed by count(). Be warned that this fetches ALL
> of the query result into PHP meory which can cause serious performance
> and/or memory problems for large result sets.
>
> 2. Use a COUNT(*) variant of your other query to get the number of
> results. Once you work with large result sets you would have done
> something like this anyway because you would start implementing some
> kind of paging through the result.
>
> OLLi
>
> --
> Hoshi: "Shouldn't we try to help them?"
> T'Pol: "They don't want our help."
> Hoshi: "How do you know?"
> T'Pol: "They're Klingons."
> [Enterprise]

[Back to original message]