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

Reply via email to