On Saturday 03 August 2002 07:01, Jason Caldwell wrote:
> You cannot have COUNT(*) without having GROUP BY -- hence, by search query
Not sure what you mean -- SELECT COUNT(*) FROM table; -- works fine.
> will not produce the desired results -- I'm thinking that there may be
> something within PHP or MySQL (a Function) that reports the total found for
> a query whether or not a LIMIT clause is used?
You need 2 queries.
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
An optimist believes we live in the best world possible;
a pessimist fears this is true.
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php