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
