Re: Re: PHP4 and MySql - Search Results Question?
| From: | Jason Wong | Date: | Sat, 03 Aug 2002 04:33:52 +0000 |
| Subject: | Re: Re: PHP4 and MySql - Search Results Question? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-110923@lists.php.net to get a copy of this message | ||
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.
*/