SELECT COUNT(*) FROM whatever WHERE whatever
to determine how many rows a particular query will return (then use this count
to assist with pagination).
The problem is that this does not work if the query contains a GROUP BY
statement as, of course,
the query will return many rows each with a count by each grouping.
Does anyone know an efficient way to determine the number of ROWS a query with
a GROUP BY
statement will return (without just executing the entire query with no LIMIT
Thanks ... Ross
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php