large query number of rows issue solution patch

[eluser]vijinho[/eluser]
ok i see what you mean.

what if you want to count data from fields selected from only one table? no it doesn't handle that situation.

in that case i'd need to rewrite the

// replace the fields list for something less complicated
$sql = 'SELECT COUNT(1) AS rows ' . strstr($sql, 'FROM');

as another query which executes a row count within the database on the results of what $sql contains

and once that's done, the problem of reading into memory to get the row count is solved, no?

v